Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase vs Oracle - which is better?
j2brown_at_my-dejanews.com wrote in message <75hq09$5fi$1_at_nnrp1.dejanews.com>...
>You don't even need a CASE statement. If you're clever, you
>can **simulate** a case statement with Abs(), Patindex(), ASCII(),
>etc. even back in version 4.9x.
>
>
>e.g. Select 0.5*Patindex(A.condition_expression,'Y') +
> 1.0*Patindex(A.condition_expression,'N')
>
>Regards,
>J
>
Getting "cute" is not good programming practice. It will likely bite you on the booboo somewhere down the road.
Tom Received on Mon Dec 21 1998 - 00:00:00 CST
![]() |
![]() |