Not LIKE [pattern] criteria includes NULLs?

R

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?
 
D

Douglas J. Steele

No, it won't.

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

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?
Click to expand...

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]
 
Top