Guru Prasad <[EMAIL PROTECTED]> writes:
> 'select * from junk where id != 11';
> To my surprise, it displayed all the records except those which had
> 'NULL' in the 'id' field.
This is correct per spec: NULL is not a value and it doesn't act like one.
See any discussion of SQL NULLs --- Bruce's b
Dear Friends,
I created a table with no 'unique constraints' which is depicted as
follows.
create table junk (id int, name varchar);
Then, i inserted some records into the table. My table contents is listed
below.
id | name
-+--
1001.00 | bolt
1002.00 | nut
