Remove scientific notation from xml column RRS feed

  • Question

  • I have a xml column as shown below


    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


All replies