Numeric Wild Cards

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Also, I'm looking for the Wild Card in SQL server, not MS Access. I connect
to the SQL server on one piece.
 
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.
 
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.
 
Back
Top