>Has anyone used a Case in SQL Server to replace an IIF statement. I want to check to see if the person has a spouse ID and then print 'Mrs.' else ''. Any ideas?
>TIA!
>DLC

Select *, NewField=case when SpouseId is Null then '' else 'Mrs' end ...