"NOT IN" Statement Help - Wildcard

[jaycast]

I have a table in SQL 7.0 that is maintained by an end user. Based on the values entered into a field in this table, I need to exclude records from a record set. Unfortunately, the user needs to be able to enter wildcards into this field.

For example, I'm looking to fulfill something like this:

Select * From tblCustomers
Where tblCustomers.SoldTo NOT IN ('LZB%')

It doesn't seem to be catching the criteria. Anyone have any suggestions of a work-around?

 

[ClaireHCM]

change 'not in' to 'not like'

 

[TDK2001]

or NOT tblCustomers.SoldTo LIKE 'LZB%'