>The value is a field in the query [in this case wkdsr.pay_type]. I did not think I could pass an IIF to SQL Server through SQL Passthough? Right now, I am passing a CASE statement within the SELECT statement that is executing properly, but I need another CASE statement nested inside the other CASE statement. [The original code was VFP6 for local data and used nested IIF statements. This is what I am trying to replace as we move the system to client/server.]
>
>Thanks again for your help.
>Doug

Doug... I didn't think you could use CASE in SQL pass through... I am in shock that that works...

It sounds like you have a complicated enough 'query' to perhaps write a back end stored procedure to generate the record set.

BOb