Not like

[Guest]

Not Like "WF*" eliminates anything that starts with WF (good) and any null
values (not good). The solution was to change the Criteria to Not like "WF*"
OR Is Null.
My question is why didn't the simple "not like" work? Is this what is
expected?
Thanks
WAL

 

[Douglas J. Steele]

Due to Null's special nature, you can't use standard boolean operators like
=, <>, Like or Not Like to check Null values.

Remember that Null means "Value unknown". If it's unknown, then it could
start with WF...