How to use "IF" in sql query

[Mighty]

Folks,

I have the following query that runs on an Access table:

SELECT IIF([Invoice Master].STYPE_31 = 'CU', 1, -1)*[Invoice Detail].INVQTY_32 AS totalSales
FROM [Invoice Master] INNER JOIN [Invoice Detail] ON [Invoice Master].INVCE_31 = [Invoice Detail].INVCE_32

How to I translate the IIF section of this query so that it will work on a Pervasive SQL table with the same structure?

Mighty

 

[Mighty]

Made some stupid errors in the query. Just replaced the IIF with IF and it seems to work fine - does that make sense??

Mighty

 

[mirtheil]

Yes, it does. It appears that "IIF" is the Access version of "IF" (as seen at

http://www.techonthenet.com/access/functions/advanced/iif.php)

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com