Re: Conditional Select statement

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 - 10:34:25 CDT