Re: I am looking for substitution of CASE or IF in SELECT

Oracle does have a CASE inSQL,
but only in version 8.1.6; can you
switch to that version ?

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Michal Kulakovsky wrote in message <3997d875.0_at_news.cvut.cz>...


>I am migrating from MS SQL and there I used CASE in SELECT

>

>like this

>

>SELECT CASE WHEN

>    datepart(wk,getdate()) >= $S1 THEN '1'

> ELSE '0'

> END "ok" from table1;

>

>Does Oracle support something like MS-SQL    CASE  in SELECT ?

>

>Can anyone help me ?

>

>Thank you.