Re: Conditional Select statement

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Wed, 4 Apr 2001 17:22:29 +0100
Message-ID: <986401372.25530.0.nnrp-12.c30bdde2@news.demon.co.uk>

or, post in comp.databases.sybase perhaps for the sybase version?

"The Ghost" <The_at_Ghost.com> wrote in message news:5aHy6.18908$XV.4868342_at_news3.rdc1.on.home.com...
> select decode(field,'OK','this is the correct value','this is not the
> correct_value')
> from your_table
>
>
> "Jon" <jzuazoa_at_nexo.es> wrote in message
> news:9afe0b$bn1$1_at_unbe.sarenet.es...
> > Hi,
> >
> > I would like to know if it is posible to add some conditional behaivour
to
a
> > select statement. I mean that if have a table that contains sometimes
the
> > 'OK' value and 'FAIL' for other rows so I could create a statement that
when
> > the row contains 'OK' it would print 'this is the correct value' and on
the
> > other hand when it contains 'FAIL' it just prints 'this is not the
correct
> > value'
> >
> >
> > Thanks for you help
> >
> > PS. this task is accomplish in SYBASE using 'CASE WHEN...'
> >
> >
>
>
Received on Wed Apr 04 2001 - 11:22:29 CDT