Re: Case in Select Statement
Tambi Dude napisaďż˝(a):
> JPS wrote:
>> I try to use "as name" statement after "case", but dbaccess return
>> syntax error.
>
> I think "as name" should come after "end case"
>
> SELECT field1, field2, field3, field4,
> case
> when char_length(field5) > 3 then substr(field5,0,2)
> else field5
> end case as name>
> FROM table1
>
> WHERE
> field1=22
> AND field2 IS NULL
>
> ORDER BY field2
>
>
Unfortunately Informix return in this situation Syntax Error.
"as name" clause raise this error.
Best regards
--
Janek