On Tue, May 02, 2006 at 10:34:12 +0000, James <[EMAIL PROTECTED]> wrote: > > i've encounter bug where when a field is empty / null (type varchar(255) ), > when i use the sql query <> 'myvalue', it seems to be false all the time.
Empty and NULL are not the same thing. NULL <> to any value evaluates to NULL which will not satisfy a WHERE clause. This is according to the SQL (i.e. it's not a bug). ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
