locked
Remove scientific notation from xml column RRS feed

  • 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

    Friday, May 24, 2013 10:19 AM

Answers

All replies