Do we have something similar to 'Decode' ??

[prasadmokashi]

Hi,

I am very new to Sybase.

Could you please tell me, similar to Oracle do we have something like 'Decode' in sybase ?

Thanks & Regards,
Prasad

 

[rebriggs]

Prasad,

I've found that in Oracle and Sybase the 'CASE' statments are easier to code and understand.

 

[dickiebird]

There's no equivalent to decode
but, as rebriggs says - case is your friend.
I reckon 'case' can look a bit clumsy compared to 'decode'
but that's just personal.
HTH

Dickie Bird (-)))

 

[prasadmokashi]

Thank you very much for your quick response.

I tried CASE statement & it works fine.

Dickie, as u said for those who are used to 'Decode', 'CASE' really seems a bit clumsy.

Thanks & Regards,
Prasad