Not like * wildcard not working

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I am inputing the not like function in Microsoft query and it is not
filtering out the data.

I use (Not Like '*MRB*') on a text field. What should I use to filter out
all records that exclude a word MRB in a text field? Thanks
 
Hello,

I am inputing the not like function in Microsoft query and it is not
filtering out the data.

I use (Not Like '*MRB*') on a text field. What should I use to filter out
all records that exclude a word MRB in a text field? Thanks
Click to expand...

There is a double negative in your request, and I'm not sure I understand what
you want. You say "filter out all records that exclude a word" - do you mean
that you want to show all records which DO NOT have "MRB" somewhere in the
field? or do you want to EXCLUDE those records which DO NOT have "MRB"?
 
Back
Top