If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If Like "#*" gives me everything that starts with a number, what do I use to get only alpha?
This gives me everything that starts with a number, Like "#*"
How do I get everything that starts with an alpha character? I guess Not Like "#*" would be an option. I'm still curious if there's a way to tell it alpha. Thanks Kelvin |
#2
|
|||
|
|||
If Like "#*" gives me everything that starts with a number, what d
I guess Not Like "#*" would be an option.
What did you get when you tried it????????? "Kelvin" wrote: This gives me everything that starts with a number, Like "#*" How do I get everything that starts with an alpha character? I guess Not Like "#*" would be an option. I'm still curious if there's a way to tell it alpha. Thanks Kelvin |
#3
|
|||
|
|||
If Like "#*" gives me everything that starts with a number, what d
It gave me what I wanted.
I was hoping someone could tell me that the alpha equivilent of the numeric # is? Kelvin "KARL DEWEY" wrote in message ... I guess Not Like "#*" would be an option. What did you get when you tried it????????? "Kelvin" wrote: This gives me everything that starts with a number, Like "#*" How do I get everything that starts with an alpha character? I guess Not Like "#*" would be an option. I'm still curious if there's a way to tell it alpha. Thanks Kelvin |
#4
|
|||
|
|||
If Like "#*" gives me everything that starts with a number, wh
From Access 2007 Help --
ANSI-89 wildcard characters Use this set of wildcard characters when you use the Find and Replace dialog box to find and optionally replace data in an Access database or an Access project. You also use these characters when you run select and update queries against an Access database, but you do not use them in queries run against an Access project. For more information about using select and update queries, see the articles Create a simple select query and Update the data in a database. Character Description Example * Matches any number of characters. You can use the asterisk (*) anywhere in a character string. wh* finds what, white, and why, but not awhile or watch. ? Matches any single alphabetic character. B?ll finds ball, bell, and bill. [ ] Matches any single character within the brackets. B[ae]ll finds ball and bell, but not bill. ! Matches any character not in the brackets. b[!ae]ll finds bill and bull, but not ball or bell. - Matches any one of a range of characters. You must specify the range in ascending order (A to Z, not Z to A). b[a-c]d finds bad, bbd, and bcd. # Matches any single numeric character. 1#3 finds 103, 113, and 123. "Kelvin" wrote: It gave me what I wanted. I was hoping someone could tell me that the alpha equivilent of the numeric # is? Kelvin "KARL DEWEY" wrote in message ... I guess Not Like "#*" would be an option. What did you get when you tried it????????? "Kelvin" wrote: This gives me everything that starts with a number, Like "#*" How do I get everything that starts with an alpha character? I guess Not Like "#*" would be an option. I'm still curious if there's a way to tell it alpha. Thanks Kelvin |
#5
|
|||
|
|||
If Like "#*" gives me everything that starts with a number, whatdo I use to get only alpha?
If you want only the letters a to z (or A to Z - both the same in
Access) then you can use Like "[a-z]*" If you want records that don't start with a number (but can start with other non-alphabetic characters then Not Like "#*" Or this does the same thing Like "[!0-9]*" '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === Kelvin wrote: This gives me everything that starts with a number, Like "#*" How do I get everything that starts with an alpha character? I guess Not Like "#*" would be an option. I'm still curious if there's a way to tell it alpha. Thanks Kelvin |
Thread Tools | |
Display Modes | |
|
|