>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

Yeah,

result = case when spouseid = 1 then 'Mrs.' else '' end