Case statement

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  September 4, 2013 at 12:38 am

  #282754

  Please help to write the SQL query in a more cleaner way...

  CASE ISNULL(TCBOV.cboValueName, '') WHEN '' THEN ''

  ELSE TCBOV.cboValueName

  END

  Thanks

• HanShi

  SSC-Dedicated

  Points: 33510

  More actions

  September 4, 2013 at 12:57 am

  #1647190

  Junglee_George (9/4/2013)

  ---

  Please help to write the SQL query in a more cleaner way...

  CASE ISNULL(TCBOV.cboValueName, '') WHEN '' THEN ''

  ELSE TCBOV.cboValueName

  END

  Thanks

  You don't have to use a CASE statement for this, just a ISNULL or COALESCE within the SELECT.

  SELECT ISNULL(TCBOV.cboValueName, '')

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• andrea.gnemmi

  Mr or Mrs. 500

  Points: 545

  More actions

  September 10, 2013 at 1:29 am

  #1648737

  I agree, I would use a COALESCE statement.

• Amit Raut

  SSCrazy

  Points: 2613

  More actions

  September 11, 2013 at 6:29 pm

  #1649544

  If you need to handle another condition along with NULL, you may write something like

  CASE

  WHEN TCBOV.cboValueName IS NOT NULL THEN

  CASE TCBOV.cboValueName

  WHEN 10 THEN 'Value1'

  WHEN 20 THEN 'Value2'

  ELSE TCBOV.cboValueName

  END

  ELSE 'No Value'

  END