Data Conversion ( varchar to decimal)

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  January 15, 2005 at 8:40 pm

  #61222

  Hi,

  I am having trouble in convert the data from one data type to another. I have a column which is declared as varchar(100) and it contains decimal values like

  column

  --------

  0.4567777777778999999999345677777777777777777

  10.3456789002322222222222545465565767888888888888888

  I want to convert this and place into another column which is of type decimal(10,4). The problem is the column contains more than 38 digits which is the maximum precision for decimals provided by sql server. So I'm getting error 'arithmetic out of range exception' while trying to use convert function. How should I do this? Please let me know.

  I need the result to be

  column

  ---------

  0.4567

  10.3456

  Thanks,

  Sridhar!!

• btoum.roumada

  SSC Enthusiast

  Points: 159

  More actions

  January 16, 2005 at 11:42 am

  #537595

  Would this work for you? 

  CONVERT(DECIMAL(10,4),LEFT(@test), @@MAX_PRECISION))

  Where @test-2 is the numeric value (varchar)

• btoum.roumada

  SSC Enthusiast

  Points: 159

  More actions

  January 16, 2005 at 11:43 am

  #537596

  Sorry typo

  CONVERT(DECIMAL(10,4), LEFT(@test, @@MAX_PRECISION))