Data base CASE

CASE WHEN dbo.vwForwardingLetter.ChalanDate = '01/01/1900' THEN NULL ELSE dbo.vwForwardingLetter.ChalanDate END

CASE WHEN dbo.vwSchemeAmntRecv.SchemeType = 'R' THEN 'Recurring' ELSE CASE WHEN dbo.vwSchemeAmntRecv.SchemeType = 'F' THEN 'Fixed' ELSE 'MIS' END END