Null Rows

• Douceur

  Grasshopper

  Points: 11

  More actions

  December 16, 2003 at 8:35 am

  #358777

  New to SQL, created a table and it has NULL rows, all fields are NULL and cannot figure out how to get rid of these rows?

  Thanks in advance.

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  December 16, 2003 at 8:43 am

  #486417

  try:

  delete from your_table

  where col1 is null and col2 is null and col3 is null

  Basically have a "is null" statement for every column in the table.

  Gregory A. Larsen, DBA

  Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp

  Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• Douceur

  Grasshopper

  Points: 11

  More actions

  December 16, 2003 at 8:46 am

  #486418

  Thank you so much!

  Happy Holidays!