>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
Oracle supports CASE statements in the SELECT - you can get IIF functionality with that
Arnon
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only