Function IIF in ADP

J

Jose Perdigao

In MDBi use IIF function. How can I use this function in ADP ( view or sp)?
There is a similiar function?
Thnks
José
 
G

Gerhard

SELECT Table.Field1, CASE WHEN Table.Field = Krit THEN Value1 ELSE
Value2 END AS IIfVal FROM Table WHERE...

Greetings from Würzburg

Gerhard
 
J

Jose Perdigao

Thanks Gerhard,
It works but is more complex and we spend more time than function iif in mdb
Regards
Jose

SELECT Table.Field1, CASE WHEN Table.Field = Krit THEN Value1 ELSE
Value2 END AS IIfVal FROM Table WHERE...

Greetings from Würzburg

Gerhard
 
G

giorgio rancati

Hi Jose,

IMHO the T-Sql CASE function is better of Jet's IIF function

see the Examples
 
Top