Numeric Wild Cards

[Guest]

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

 

[Guest]

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

 

[Dirk Goldgar]

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

How about

Like '1[0-9]er'

? That would match a single numeric digit.

 

[Marshall Barton]

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

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