Remove scientific notation from xml column

Question

I have a xml column as shown below

<Root>
  <Row>
    <Rowid>1</Rowid>
    <date>2013-05-06</date>
    <Balance>1.0002E7</Balance>
  </Row>
</Root>

When i query for getting balance i do get it as 1.0002E7 . But i want to get it as 10002000 .

How can i do it?

I have another question. Can i make any changes so that in xml column it self it store as i required without scientific notation.

Thank you

Answer 1

Hello,

That's the quite normal XML notification for float values and if you handle it correctly as a float, then you get a correct result.

See http://www.w3.org/TR/2001/REC-xmlschema-2-20010502/#lexical-space

---

Olaf Helper

Blog Xing

Answer 2

You can do conversion to decimal:

SELECT CONVERT(DECIMAL(20,0), 1.0002E7 );
-- 10002000

---

Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012