List:General Discussion« Previous MessageNext Message »
From:leegold Date:March 29 2005 9:58pm
Subject:selecting fields with NULL
View as plain text  
 Hi,

I understand that we should use "IS" instead of "=" for selecting fields
with NULL. But then, shouldn't the statement below cause a syntax error?
Please explain. 

select * from test2 where datecurrent=NULL;

Thanks,
Lee
Thread
selecting fields with NULLleegold29 Mar
  • Re: selecting fields with NULLSGreen30 Mar