• 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