>>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

Thanks! That is what I needed.
DLC