This is a common problem when dealing with floating point data. Even relatively small decimal numbers can't be represented exactly, and different systems handle string conversion differently.

Try this

CONVERT(t1.volume, NUMERIC) || ' ' || t1.vunits as volume