Home Forums SQL Server 2008 SQL Server Newbies Case statement RE: Case statement

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