selecting a NULL value?????

Hello...

Here is a select statement:

SELECT *
FROM this_table
WHERE (char_field = ''
OR char_field = null )

this_table.char_field contains nothing. Why does this SQL statement not work?

thanks in advance
larry Received on Mon Aug 24 1998 - 16:00:29 CDT