How to query for an *

  • Thread starter Thread starter JamesSF
  • Start date Start date
J

JamesSF

Hello

I need to remove about 20,000 records from a table that has ** in the last 2
digits of a 10 digit number.

since * is also the wildcard, how can i select or filter for any record that
end with **?

thanks in advance
james
 
JamesSF wrote in message said:
Hello

I need to remove about 20,000 records from a table that has ** in the last 2
digits of a 10 digit number.

since * is also the wildcard, how can i select or filter for any record that
end with **?

thanks in advance
james
Click to expand...

Place the wildcards in [brackets]

Where somefield like "*[**]"
 
perfect guys - thanks!


RoyVidar said:
JamesSF wrote in message said:
Hello

I need to remove about 20,000 records from a table that has ** in the
last 2 digits of a 10 digit number.

since * is also the wildcard, how can i select or filter for any record
that end with **?

thanks in advance
james
Click to expand...

Place the wildcards in [brackets]

Where somefield like "*[**]"
Click to expand...
 
Use one of the following criteria

Like "*[*][*]"

or

Field: LastTwo: Right([NumberField],2)
Criteria: "**"
 
Back
Top