I don't know if this is directly an XML oriented question, or if SQL Server has something to do with it, but here it goes.

I've got my select statement
SELECT Data.query('sum(//Needs/CurrentIncome)') FROM Cache
Where Data is an xml column, and the CurrentIncome nodes of the xml blob all contain numeric data. The problem is that the result of the sum() call is returning the numbers in scientific notation. Which means I can't convert the results to numbers, which is what I really need to do. The results are large numbers, but no where near any sort of numeric data type limit.

So is there something I can do to change the result format?