[RESOLVED] a simple query problem regarding NULL value

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

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

Where SNO Is Null

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

Quote:

---

Originally Posted by brucevde

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

Where SNO Is Null

---