Basic Data conversion doubt

• Roy Rogers

  SSCertifiable

  Points: 7712

  More actions

  January 22, 2007 at 1:21 pm

  #171927

  SELECT CONVERT(NUMERIC(28, 2), 2.5608655E7)

  --works okay

  SELECT CONVERT(NUMERIC(28, 2), '2.5608655E7')

  --throws error

  How to convert the varchar value ins table to 25608655.00

  DECLARE @MyTable TABLE

  (

  NumVal VARCHAR(25)

  )

  INSERT @MyTable

  SELECT '2.5608655E7'

  -- now I need a value 25608655.00 in the results without the error

  /*

  Server: Msg 8114, Level 16, State 5, Line 11

  Error converting data type varchar to numeric.

  */

  SELECT CONVERT(NUMERIC(28, 2), NumVal) FROM @MyTable

  Regards,
  gova

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  January 22, 2007 at 1:31 pm

  #684792

  SELECT CONVERT(NUMERIC(28, 2), CONVERT(FLOAT, '2.5608655E7'))

  _____________
  Code for TallyGenerator

• Roy Rogers

  SSCertifiable

  Points: 7712

  More actions

  January 22, 2007 at 1:46 pm

  #684795

  Thanks Sergy.

  I was trying all data types and just found Real and float works.

  Regards,
  gova