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