View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 07:13 AM
Tzvika Barenholz
 
Posts: n/a
Default 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

Reply With Quote