>Er...That's not really a fool-proof assumption, ya know?
>
>>when spouseid = 1 then 'Mrs.'

Yes, I know. We will be using another Salutation field that the user can enter whatever they want.

It was just an exercise so that the next time I come across an IIF that is going to SQL Server that I will know how to convert it.

DLC