Post reply

changing datatypes (Real->Decimal)

  • February 5, 2003 at 12:20 pm

    #357701

    Hello,

    Wrote myself into a BIG problem and hoping that someone can throw me a rope. I've created and populated several tables that use the REAL datatype for numbers. Programming considerations are such now that I have to change them to DECIMAL. The problem is that alot of the REAL numbers which are stored as 106935555 (1.069356E+08) when I convert it to DECIMAL(Scale 10) I get 106935552.

    Is there ANY way I can get back to my original numbers?

    Regards,

    Christopher Klein

  • February 5, 2003 at 2:25 pm

    #448127

    Unfortunately, no. The reason is there is not precise but approximate with Real and Float as stated in BOL so recovering the exact original number is impossible.

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

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