Problem in converting float to varchar

• aravind-305595

  Ten Centuries

  Points: 1389

  More actions

  October 21, 2008 at 2:47 am

  #194778

  The following query truncates the decimal characters when we convert it to varchar.

  declare @d float

  declare @d1 float

  select @d = 34343.454

  select @d1 = 676.1566545

  select cast (@d as varchar(50)) + CHAR (9) + cast (@d1 as varchar(50))

  ouput:

  34343.5 676.157

  but the required output is:

  34343.454 676.1566545

  Can anyone help to find a best solution for this ?

  Thanks in advance.

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  October 21, 2008 at 2:53 am

  #887478

  I tried the below code

  declare @d float

  declare @d1 float

  select @d = 34343.454

  select @d1 = 676.1566545

  select cast (@d as varchar(50))

  select cast (@d1 as varchar(50))

  I got the below output.

  34343.453999999998

  676.15665449999995

  karthik

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  October 21, 2008 at 5:43 am

  #887529

  aravind (10/21/2008)

  ---

  The following query truncates the decimal characters when we convert it to varchar.

  declare @d float

  declare @d1 float

  select @d = 34343.454

  select @d1 = 676.1566545

  select cast (@d as varchar(50)) + CHAR (9) + cast (@d1 as varchar(50))

  ouput:

  34343.5 676.157

  but the required output is:

  34343.454 676.1566545

  Can anyone help to find a best solution for this ?

  Thanks in advance.

  declare @d float

  declare @d1 float

  select @d = '34343.454'

  select @d1 = 676.1566545

  select cast(cast (@d as decimal(12,3)) as varchar(20)) + CHAR (9) + cast(cast (@d1 as decimal(12,3)) as varchar(20))

  ---

  Madhivanan

  Failing to plan is Planning to fail

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  October 21, 2008 at 11:38 pm

  #887947

  aravind (10/21/2008)

  ---

  Can anyone help to find a best solution for this ?

  Thanks in advance.

  I can.

  Simply by opening BOL on related topic.

  _____________
  Code for TallyGenerator

• aravind-305595

  Ten Centuries

  Points: 1389

  More actions

  October 23, 2008 at 7:36 am

  #888591

  Hi Madi,

  The output wont be the one I expected. The decimal should not get truncated.

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  October 23, 2008 at 7:48 am

  #888598

  aravind (10/23/2008)

  ---

  Hi Madi,

  The output wont be the one I expected. The decimal should not get truncated.

  Here it is

  declare @d float

  declare @d1 float

  select @d = '34343.454'

  select @d1 = '676.1566545'

  select cast(cast (@d as decimal(12,3)) as varchar(20)) + CHAR (9) + cast(cast (@d1 as decimal(18,7)) as varchar(20))

  ---

  Madhivanan

  Failing to plan is Planning to fail