using LIKE

  • Thread starter Thread starter JSP
  • Start date Start date
J

JSP

hi
im using these code to get allr ecords that begin with a number

select Field From Table where field like '#*'

instead of the '#' sign, what is the apropiate wildcard to reference a
letter (alpha char) a-z A-Z?


thanks in advance !
 
hi
im using these code to get allr ecords that begin with a number

select Field From Table where field like '#*'

instead of the '#' sign, what is the apropiate wildcard to reference a
letter (alpha char) a-z A-Z?

thanks in advance !
Click to expand...

Where [field] like [Enter Letter] & "*"
 
You might try
NOT Like "#*"
though that would return records that started with a space or a slash or any
other non-numeric character.

So possibly the following will work for you.
Like "[a-z]*"
 
Back
Top