Code Forums - View Single Post

bdl · 01-26-2004, 06:40 PM

To further expand on sde's statement, you can combine the two easily to match any column without value or with an empty string, e.g.

Code:

SELECT * FROM sometable WHERE field IS NULL OR field = '';

Please note you can't use 'WHERE field = NULL' because any operation on NULL like that always returns NULL.

And yes you can use either the <> or != operators to signify the NOT.

01-26-2004, 06:40 PM	#7 (permalink)
bdl Senior Contributor Join Date: May 2002 Location: vta.ca.usa Posts: 555	To further expand on sde's statement, you can combine the two easily to match any column without value or with an empty string, e.g. Code: SELECT * FROM sometable WHERE field IS NULL OR field = ''; Please note you can't use 'WHERE field = NULL' because any operation on NULL like that always returns NULL. And yes you can use either the <> or != operators to signify the NOT.