Home Forums SQL Server 2008 SQL Server Newbies Case statement RE: Case 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'