topic Where statement not working in QlikView

Where statement not working

Tue, 26 Apr 2011 20:21:56 GMT

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

Where statement not working

Anonymous — Tue, 26 Apr 2011 20:26:31 GMT

Try replacing * with %?

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

Where statement not working

Tue, 26 Apr 2011 20:32:01 GMT

That did the trick. Thanks Dinesh!