selecting fields with NULL

[leegold]

 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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]