How to query for an *

[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

 

[RoyVidar]

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

Place the wildcards in [brackets]

Where somefield like "*[**]"

 

[Allen Browne]

Try enclosing the character in square brackets, e.g.:
Like "*[*]"

 

[JamesSF]

perfect guys - thanks!

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

Place the wildcards in [brackets]

Where somefield like "*[**]"

 

[John Spencer]

Use one of the following criteria

Like "*[*][*]"

or

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