re select where... please read this not previous 3

• thehammer-178982

  SSC Eights!

  Points: 907

  More actions

  January 26, 2005 at 4:20 am

  #61229

  I have a table

  date     datetime

  text1    nvarchar

  text2    nvarchar

  I am running the following code

  select CONVERT(VARCHAR(8),date)) + ',' +

       text1 + ','

  from table;

  which returns

  Jan 26,abcdefg,

  When I add text2 to the select statement, which at this moment in time contains NULL, it simply returns the following

  NULL

  what I would like to see is

  Jan 26,abcdefg,NULL

  Can anyone please advise how I can get all values out of the table regardless of their value, in the format I have described.

  thanks

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 26, 2005 at 5:43 am

  #539111

  Have you looked at using ISNULL?

  select CONVERT(VARCHAR(8),date)) + ',' +

       ISNULL(text1, 'NULL') + ',' + ISNULL(text2, 'NULL')

   

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  January 26, 2005 at 5:50 am

  #539113

  The problem you are running into is common.  ANYTHING + NULL will always = NULL.

  Nicholas has provided how to get around this by changing a NULL field to be a string field with a value of "NULL"

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net