Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try replacing * with %?
SQL SELECT .. . . . . FROM MyTable WHERE upper(CustomerName) not like '%SAMPLE%';
That did the trick. Thanks Dinesh!