I am writing a pass through query to SQL.

Since the query is performed by SQL Server, does anyone know how to write the equivalent of an IIF or If then statement in the query?

With Jet database I would state something like:
SELECT IIF([Job Name] = "Stoney Creek","Yes","No") AS Job Exists
FROM MasterJobs;

If there is anything close that would deliver the same results it would help me out a ton.

Thanks,
Coby.

SELECT CASE WHEN [Job Name] = 'Stoney Creek' THEN 'Yes' ELSE 'No' END AS Job_Exists FROM MasterJobs

urt

That worked! Perfect.

I like that method a lot.
Thanks for your help and have a good weekend.
Coby.

Yes, a question, Cory. Do you really want the strings "Yes" and "No" or do you want actual boolean values of yes/true/-1 and no/false/0? If so, you want

SELECT CASE WHEN [Job Name] = 'Stoney Creek' THEN True ELSE False END AS Job_Exists FROM MasterJobs


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division