Where statement not working

[#1]

This should be simple but . . . .. I simply want to remove customers who have the name "Sample" in the field CutomerName. The table is an ODBC connection to a Microsoft Access database. I am using":

SQL SELECT .. . . . . FROM MyTable WHERE CustomerName not like '*sample*';

It is not removing the customers with Sample in their name. What am I doing wrong?

THanks,

Stephen

[Anonymous]

Try replacing * with %?

SQL SELECT .. . . . . FROM MyTable WHERE upper(CustomerName) not like '%SAMPLE%';

[#3]

That did the trick. Thanks Dinesh!