I am running a program in Microsoft SQL Server Management Studio 2008
and I need to create a column called Status which will populate 5
values from 3 separate variables (WX-LON-SUB-STA, LoanStatus,
DaysDelinquent). Is there any way to create a nested case statement
with the code that I have enclosed in this message? Any assistance
would be greatly appreciated. Thanks.
if you use in you need to enclose the list - even if it is one with ()
WHEN WX-LON-SUB-STA in ('Deferment')
WHEN WX-LON-SUB-STA = 'Deferment'