You can use "Case" SELECT c1, c2, CASE WHEN c3 = 52 THEN 0 ELSE 1 END AS base_irrf_13 FROM t1;On 4/5/06, Renato Cramer <
[EMAIL PROTECTED]> wrote:Hello all,Is the use of IF statement restrict to Functions and Store Procedures?
I'm trying to use an IF within Select...Example:create view v1
Hello all,
Is the use of IF statement restrict to Functions and Store Procedures?
I'm trying to use an IF within Select...
Example:
create view v1 as
select c1,
c2,
if c3 = 52 then 0
else 1
endif as base_irrf_13
from t1;
Thanks in advance,
Renato Cramer.
---(end o
