If Like "#*" gives me everything that starts with a number, what do I use to get only alpha?

  • Thread starter Thread starter Kelvin
  • Start date Start date
K

Kelvin

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
 
I guess Not Like "#*" would be an option.
What did you get when you tried it?????????
 
It gave me what I wanted.

I was hoping someone could tell me that the alpha equivilent of the numeric
# is?

Kelvin
 
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.
 
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
'====================================================
 
Back
Top