>I think I got it -- I had to create a cursor and then populate the cursor with several SELECT statements.
>
>Thanks for the response.
>Doug

I think that you can nest case statements in SQL Server.

I remember all those conversions of IIF().

You just have to build them right and they should fly. Did you try any in ISQL as a test bed? That's where I did my inital conversions and then copy and paste back to VFP.

__Stephen