Post reply

Display Numeric Data in Scientific Notation

  • August 16, 2009 at 11:46 pm

    #385193

    Hello Guys...

    I am trying to write a query which display or fetch Numeric Data in Scientific notation with mentions (No. of) Decimal places.

    Can anyone Explain me how can i get a Numeric Data (All Types) in Scientific Notation.

    More Over i want get comparison with data..

    e.g.

    Select* from table1 where col1(Num) = -1.06E+3.

    Now here suppose Col1 has values -1056 , and i have value in Scientific notation with two decimal places as(1.06E+3)..

    Can you please tell me how can i get copared ...

    Note: there is one restriction that i cannot change the datatype for col1.

    regards..

  • August 17, 2009 at 3:12 pm

    #1040529

    triple post.

    Further discussion here.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply