design query grid match anywhere question

[Nooby]

In the design query grid I want to match the letters "ABC" anywhere in
the
column 'description'. I could not get instr to work by using:
InStr(description, "ABC")) > 0

How else can I match ABC (upper and lowercase) to anywhere in my
'description' column?
Thanks!

 

[Nooby]

In the design query grid I want to match the letters "ABC" anywhere in
the
column 'description'. I could not get instr to work by using:
InStr(description, "ABC")) > 0

How else can I match ABC (upper and lowercase) to anywhere in my
'description' column?
Thanks!

Like "*ABC*" Thanks!

 

[Marshall Barton]

Like "*ABC*" Thanks!

The Instr will do that, but you need to use it as a
calculated field:

Field: InStr(description, "ABC")
Show: unchecked
Criteria: >0