Re: case when ... then expression

sign(x-y) give out 1, 0, -1; so you can easily have workaround with <= in decode.

"rob" <rob_at_dsdelft.nl> wrote in message news:<9hbvup$g93$1_at_news.tudelft.nl>...
> > decode(sign (x-y),1,"x is more than y","x is less than or equal to y")
> That's what I use in cases likes this. But no <= in there. I checked the
> manuals on decode and was worrying I missed something.
>
> Regards,
> Rob.
Received on Wed Jun 27 2001 - 13:29:46 CDT