Re: selecting fields with NULL

"leegold" <[EMAIL PROTECTED]> wrote on 03/29/2005 04:58:11 PM: > 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 e

selecting fields with NULL

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 Lis