CAST and CASE

[Rbar]

I want to cast the output of a case statement, but I havne't been able to get the syntax correct.

cast(case when abckey like 'star%' then abckey else '' end as char(5)) as as STATUS
3706: Syntax error: expected something between '(' and the 'case' keyword.

 

[rrrkrishnan]

Try this.

cast((case when abckey like 'star%' then abckey else '' end) as char(5)) as STATUS

 

[Rbar]

It turns out I was missing the comma to separaate SELECT statements.
Your syntax is perfect.