Re: SQL question

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Wed, 17 Nov 1999 16:01:39 -0800
Message-ID: <80vfm7$mvv$1@plo.sierra.com>

How do you know it's MALE if it's not FEMALE?

(circa 1999)

Roger Stapley <rstapley_at_uk.oracle.com> wrote in message news:383137CD.5744BE6B_at_uk.oracle.com...
> 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 Wed Nov 17 1999 - 18:01:39 CST