## Problem in converting float to varchar

 Author Message aravind-305595 Ten Centuries Group: General Forum Members Points: 1099 Visits: 119 The following query truncates the decimal characters when we convert it to varchar.declare @d floatdeclare @d1 floatselect @d = 34343.454select @d1 = 676.1566545select cast (@d as varchar(50)) + CHAR (9) + cast (@d1 as varchar(50))ouput:34343.5 676.157but the required output is:34343.454 676.1566545Can anyone help to find a best solution for this ?Thanks in advance. karthik M SSC-Insane Group: General Forum Members Points: 24061 Visits: 2591 I tried the below codedeclare @d floatdeclare @d1 floatselect @d = 34343.454select @d1 = 676.1566545select cast (@d as varchar(50))select cast (@d1 as varchar(50))I got the below output.34343.453999999998676.15665449999995 karthik Madhivanan-208264 SSCertifiable Group: General Forum Members Points: 6219 Visits: 476 aravind (10/21/2008)The following query truncates the decimal characters when we convert it to varchar.declare @d floatdeclare @d1 floatselect @d = 34343.454select @d1 = 676.1566545select cast (@d as varchar(50)) + CHAR (9) + cast (@d1 as varchar(50))ouput:34343.5 676.157but the required output is:34343.454 676.1566545Can anyone help to find a best solution for this ?Thanks in advance.`declare @d floatdeclare @d1 floatselect @d = '34343.454'select @d1 = 676.1566545select cast(cast (@d as decimal(12,3)) as varchar(20)) + CHAR (9) + cast(cast (@d1 as decimal(12,3)) as varchar(20))` MadhivananFailing to plan is Planning to fail Sergiy SSC Guru Group: General Forum Members Points: 91063 Visits: 13679 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. aravind-305595 Ten Centuries Group: General Forum Members Points: 1099 Visits: 119 Hi Madi,The output wont be the one I expected. The decimal should not get truncated. Madhivanan-208264 SSCertifiable Group: General Forum Members Points: 6219 Visits: 476 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 floatdeclare @d1 floatselect @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))` MadhivananFailing to plan is Planning to fail