find all text string in Criteria at once

[Jerseynjphillypa]

I would like to find all the text string under the field location for NJ - xxx, NJ-xxxx, NJ -xxxx,etc.

I do not want it to find NJ

I used the command Like "NJ -*"

But the problem is the space or the position of the "-". How would I be able to find all text string using the criteria all at once regardless of the extra space or "-".

[jzwp11]

This should do the trick

WHERE Table.Location Like "NJ*" and Table.Location <> "NJ"

[Jerseynjphillypa]

thank you for the help jzwp11

[jzwp11]

You're welcome.