Numeric Wild Cards

L

Lee

Is there any such character that acts strictly as a numeric wildcard?
(i.e.) l~er would pick up l9er but not lier (~ being the wildcard I am
looking for, strictly numeric numbers.)?

-Lee
 
L

Lee

Also, I'm looking for the Wild Card in SQL server, not MS Access. I connect
to the SQL server on one piece.
 
D

Dirk Goldgar

Lee said:
Is there any such character that acts strictly as a numeric wildcard?
(i.e.) l~er would pick up l9er but not lier (~ being the wildcard I
am looking for, strictly numeric numbers.)?

-Lee
Click to expand...

How about

Like '1[0-9]er'

? That would match a single numeric digit.
 
M

Marshall Barton

Lee said:
Also, I'm looking for the Wild Card in SQL server, not MS Access. I connect
to the SQL server on one piece.
Click to expand...


So will Like "l#er", at least in Jet. I don't know if SQL
Server has an equivalent.
 
Top