Post reply

Case statement

  • 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

  • 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’! **

  • September 10, 2013 at 1:29 am

    #1648737

    I agree, I would use a COALESCE statement.

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply