You are correct - I got mixed between UDB syntax and Oracle's - in Oracle you should indeed use DECODE
something like decode(greatest(num_trys,max_trys),num_trys,1,0) should work


Arnon
>I think SQL Server supports the CASE statement but I have
>not seen it in Oracle. Are you sure such an animal exists
>and can be used in the SELECT statement via SQL passthru?
>
>>>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