Col001 + Col002

• cmcilvoy

  Ten Centuries

  Points: 1015

  More actions

  August 13, 2002 at 6:36 am

  #173317

  When i do a select Col001 + Col002 as combine from table

  if Col002 is null it returns a null value, how can i prevent this. thanks

  
  </cm>

• NPeeters

  SSChampion

  Points: 12535

  More actions

  August 13, 2002 at 6:52 am

  #434486

  Depends on what the types of columns are.

  One solution is setting a database wide parameter :

  sp_dboption 'database', 'concat null yields null', 'FALSE'

  Or you can use the ISNULL function as in

  col001 + IsNull(Col002, '')