How to delete a NULL record in a Sql table?

delete from SomeTable where SomeField is null


http://sqlservercode.blogspot.com/

Actually what is problem is I am having two or three null records in my table. If I give a sql query in my program its resulting null record first. So remaining records are not resulting and I am getting error message like:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

How can I resolve this issue??

You don't want records with NULL values coming back to the frontend?

change your SQL to select * from SomeTable where SomeField is not null

http://sqlservercode.blogspot.com/

Thank you very much SqlMenace. I tried to handle the null exception through coding and delete a null records from the table. But it didnt worked out. Finally your query workedout. Thank you

Also you may want to think about replacing the null value with a '' or empty value. Assuming you have valuable and important data in the rows that have a null in one field. I suggest you look into using the isnull function and replace the fields null value with something else to allow you to return those particular rows rather than simply ignoring the whole row because one field has a null value which is what the use of "is not null" syntax will do.