I have a view with a field defined as "0.00 as totVal"
A scan through another table and hold amounts to variable and do some tallying and basic math.
when I use REPLACE to put variable value into view filed I loose decimals. My fields in the view shows 0.00 for all amounts when first created. In stepping through code I see the value has decimals but the field value looses decimals after replace.
I tried set decimal and set fixed but no effect.

Any help Appreciated
James