>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