How to convert a scientific notation number

• jay-125866

  SSCommitted

  Points: 1629

  More actions

  January 17, 2005 at 11:19 am

  #61520

  I'm trying to retrieve a 16-digit number field from a SQL Server 2000 table. Instead of showing a full 16-digit number, like 2345654687654978, it gave me a number in scientific notation format, like 2.34E+15. I've tried to convert it into a numeric format and failed. Can you help me out here?

  Thanks,

• babuganesh2000

  Hall of Fame

  Points: 3123

  More actions

  January 17, 2005 at 2:46 pm

  #537739

  Really, Iam not sure it will throw an error. Send the code segment also.

  I doubt the data type is not compatible. Better use bigint.

  If you are not going to manipulate the variable. Why not converting to varchar.

   

  Thanks,

  Ganesh

• mapperhd

  SSC-Addicted

  Points: 429

  More actions

  June 19, 2014 at 4:20 pm

  #1723436

  Disregard. This was a matter of bad data supplied by the past vendor.