sql - Invalid character found in string argument 'DECFLOAT' -

i seem having problem using filed when used in case statement. example when try:

select a.*, case when value > 0 non_zero      else value mytable

where get:

invalid character found in string argument of function 'decfloat'

usually come across type of error forgetting cast field decimal, makes no difference. if try:

select * mytable value > 0

then runs fine.

so why criteria not work within case statement?

i think forgot "end case". try this:

select a.*, case    when value > 0 non_zero   else value end case

Silver