Re: SQL question

SELECT DECODE(gender, 'F', 'Female', 'Male') FROM tablea;

marcus_chan_at_my-deja.com wrote:
>
> Hello,
>
> Is it possible to write something like this in PURE sql code .
>
> select case when gender = 'F' then 'Female'
> else then 'Male'
> end case
> from TABLEA
>
> thanks
> marcus
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Tue Nov 16 1999 - 04:54:05 CST