Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF() like Function in Oracle?
Message
From
17/05/1999 16:26:17
 
 
To
17/05/1999 16:04:31
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00219769
Message ID:
00219777
Views:
23
I think you can do what you want with a combination of DECODE and GREATEST.
Something like this maybe?

Select decode(greatest(num_trys, max_trys),num_trys, 'true', max_trys, 'false') from table

>Is there a function in Oracle that emulates what
>the VFP IIF() function does? The closest thing
>I have seen is the DECODE() function.
>
>What I need to do is as follows in a SQL passthru statement:
>
>IIF(num_trys > max_trys, 'True', 'False') AS fieldname
Previous
Reply
Map
View

Click here to load this message in the networking platform