Re: Compare Values in a Decode

decode (greatest(x,y), x, x_is_greater_y , y_greater_or_equal_x)

you can use greatest or least.

there are building SQL functions

check the Oracle Sql manual

In article <6i7gcj$pcg$1_at_nnrp1.dejanews.com>, pjklimt_at_mailexcite.com wrote:
>I want to compare a value in a Decode to see if it is greater then another
>value. Depending on the outcome I want to post a different message. for
>example in code I would write "IF (1 > 0){'True'}else{'False'}". I tried
>DECODE(FIELD > 0, TRUE, 'True', 'False) to no avail. Thanks in Advance.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Wed Apr 29 1998 - 14:34:17 CDT