WHERE field = (NULL)?

[vaska]

hi all...

i'm trying to do a query that searches WHERE field = (nothing)

meaning, there is nothing in the field in the field...a blank NULL field...how do it get it to do that?

thanks...vaska

[stolzyboy]

SELECT * FROM table where field IS NULL

[vaska]

thanks...in all my searching around the forum i never found that...

of course, i used <> instead already...jv