Not LIKE [pattern] criteria includes NULLs?

[ronaldlum]

The subject of this post basically outlines the question. If I use a
Not LIKE [pattern] under criteria for a select query, will the query
pick up records with a NULL value?

 

[Douglas J. Steele]

No, it won't.

Wouldn't it have been faster just to try it than to post a question?

 

[John W. Vinson]

The subject of this post basically outlines the question. If I use a
Not LIKE [pattern] under criteria for a select query, will the query
pick up records with a NULL value?

Nope. NULL is not equal to anything, not LIKE anything, not *unequal* to
anything, and not NOT LIKE anything. Any comparison with NULL returns NULL,
which is treated as False by the query engine; the one exception is

IS NULL

John W. Vinson [MVP]