[thelist] Front End Access access to SQL DB's

[Rob Smith]

>> I'm almost finished with the conversion, but what I want to know is, if
>> queries that use IIF's, for example, are interpreted correctly by SQL
>> server?

> nope, you need to change the syntax from IIF to CASE

That's odd. In fact there were 4 columns of nested IIF statements using
linked tables to an SQL server and the queries ran fine.

Can anyone explain this? I have an idea but want to get a second opinion.

Rob