ISNULL(date,'-')

• techvech

  Newbie

  Points: 7

  More actions

  September 1, 2009 at 4:07 am

  #133338

  hi

  I am new to SQL

  i wanted to know,

  how can i show date as '-' when it is NULL or EMPTY in the database ?

  thanks...

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 1, 2009 at 6:15 am

  #1047444

  Do it on the application side, you don't need to do it in SQL.

  -- Gianluca Sartori

• Lamprey13

  SSCertifiable

  Points: 6210

  More actions

  September 1, 2009 at 1:45 pm

  #1047789

  Gianluca Sartori (9/1/2009)

  ---

  Do it on the application side, you don't need to do it in SQL.

  Totally agree.

  However, if you insist on doing it in SQL you can do it in several ways, here are four:DECLARE @MyDate DATETIME

  --SET @MyDate = CURRENT_TIMESTAMP

  SELECT

  COALESCE(CAST(@MyDate AS VARCHAR(25)), CAST('-' AS VARCHAR(25))) AS Method1,

  COALESCE(CONVERT(VARCHAR(25), @MyDate, 103), CAST('-' AS VARCHAR(25))) AS Method2,

  CASE

  WHEN @MyDate IS NULL THEN CAST('-' AS VARCHAR(25))

  ELSE CAST(@MyDate AS VARCHAR(25))

  END AS Method3,

  CASE

  WHEN @MyDate IS NULL THEN CAST('-' AS VARCHAR(25))

  ELSE CONVERT(VARCHAR(25), @MyDate, 103) -- Or other format

  END AS Method4