Lowell (1/28/2015)

---

you'd have to convert to varchar, are you sure that's what you want?

ACTLABCOST = case

when ACTLABCOST = 0

then '.00'

else convert(varchar,ACTLABCOST)

end,

ACTMATCOST = case

when ACTMATCOST = 0

then '.00'

else convert(varchar,ACTMATCOST)

end,

krypto69 (1/28/2015)

---

Thanks Lowell That worked perfectly.

Just curious why must that be converted to varchar?