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