Using Not Like criteria

[robojeff]

I am attempting to use the Not like criteria in a query but am not sure how the syntax of this should be....

The data that I want to filter out with my criteria is:

"OBL/

With the leading " in the field...

Apreciate any tips on how to set a "not like criteria" on the

'OBL/

thanks

 

[Remou]

As in:

Not Like "*""OBL/*

 

[PHV]

Not Like '*"OBL/*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886