Re: Error converting data type varchar to float Hi JayPee
You case statement is illegal because '--' is actually a varchar.
what do you want the return to be ? what is the function.
you could cast final as varchar and then return something like
when '0' then '--' else cast(final as varchar)
or if you need to keep it as float, i suggest putting null instead of
'--' and then running is_null on that.
hope this helps
Tzvika |