Function IIF in ADP

[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é

 

[Gerhard]

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

Greetings from Würzburg

Gerhard

 

[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

 

[giorgio rancati]

Hi Jose,

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

see the Examples