SQL XML, formatting floats, suppressing trailing zeroes
User round(val, digits) to round a floating point number to a specific number of decimal digits.
To avoid having lots of extra digits appear in the xml however, you can convert the float to a char. Trailing zeros then disappear from the xml. Go figure.