[RESOLVED] a simple query problem regarding NULL value

[raghunadhs]

Hi All,
i started some practice on SQL server 2000. i have a table called "student". its fields are sno,sname .unfortunately this table is containing NULL values. now i would like to delete the rows whose sno=NULL. so i wrote the query like this.... DELETE STUDENT WHERE SNO= NULL

but this statement is not helpful to delete the rows. could you suggest me a way to solve it?

Thanks & Regards,
raghunadhs

[brucevde]

In TSQL, to check if a value equals Null you need to use

Where SNO Is Null

[raghunadhs]

Thanks brucevde,
it is working...
regards,
raghunadhs

In TSQL, to check if a value equals Null you need to use

Where SNO Is Null