Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    NJ USA
    Posts
    19

    Unanswered: Convert real to Varchar.

    Hello All,

    I am facing problem to get exacltly value using convert function. Please follow below steps.

    Crete table A (ID Real)

    Insert into A values(0.0000013)

    Select * from A

    ----------------
    1.3 e-05

    I am getting '1.3 e-05' values because datatype is real so that is why I am getting but want to get '0.0000013' values. Please let me know what have to that for that.

    Please let me know asap.

    Regards,
    M Jain
    NJ,USA
    M. Jain

  2. #2
    Join Date
    Nov 2003
    Posts
    48
    You can convert "REAL" into "NUMERIC" first and then
    convert to varchar.

    like,

    select convert(varchar, convert(NUMERIC(30,20), id)) from A
    Last edited by shianmiin; 11-13-03 at 18:50.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •