By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Passthru query issue with IIF

P: n/a
Hi All,

In AccessXP I'm trying to change a query I have to a 'passthru' query
and its failing. I think its due the fact that I have an 'IIF' in it.

What is the sql equivalant to Access ' IIF '
bobh.

Sep 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sep 14, 10:25 am, bobh <vulca...@yahoo.comwrote:
Hi All,

In AccessXP I'm trying to change a query I have to a 'passthru' query
and its failing. I think its due the fact that I have an 'IIF' in it.

What is the sql equivalant to Access ' IIF '
bobh.
It will vary depending on what the target DBMS is. The Oracle SQL
equivalent is "DECODE".
Sep 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.