Re: Sybase vs Oracle - which is better?

In comp.databases.sybase denny_vk_at_my-dejanews.com wrote: .....
: > UPDATE tablename as A
: > SET fieldname = (select
: > sum(B.fieldname)*decode(A.condition_expression,'Y',0.5,1)
: > FROM tablename2 B
: > where B.fkey = A.key)
: > WHERE <some further restrictions>;
 

: Remember Sybase does not have decode or user defined functions.

Sybase has a CASE expression. I'm not that familiar with the decode function, but I think that Sybase's CASE expression provides at least the same functionallity as the decode function.

-- 
Luc.

______________________________________________________________________
Luc Van der Veurst                                      ISUG President
Academic Hospital, VUB                             http://www.isug.com
Laarbeeklaan 101, 1090 Brussels, Belgium
32 - 2 477 69 80       
lucv_at_az.vub.ac.be