Combining two Columns; one with Null Values

• cmcilvoy

  Ten Centuries

  Points: 1015

  More actions

  July 6, 2002 at 11:54 am

  #78346

  SELECT tbl.id, tbl.sku,

  tbl.sizevalue + ' ' + tbl.colorvalue + ' ' + tbl.widthvalue as sizecolorwidth

  FROM tbl

  if the widthvalue has a null value the whole field returns a null. how can i prevent this? thanks

  
  </cm>

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 6, 2002 at 1:20 pm

  #432146

  One way is to set concat_null_yields_null off. A better approach is to test each value with isnull and convert it to an empty string.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter