J Jose Perdigao Feb 2, 2006 #1 In MDBi use IIF function. How can I use this function in ADP ( view or sp)? There is a similiar function? Thnks José
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 Feb 2, 2006 #2 SELECT Table.Field1, CASE WHEN Table.Field = Krit THEN Value1 ELSE Value2 END AS IIfVal FROM Table WHERE... Greetings from Würzburg 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 Feb 2, 2006 #3 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
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 Feb 2, 2006 #4 Hi Jose, IMHO the T-Sql CASE function is better of Jet's IIF function see the Examples
