Home Forums SQL Server 7,2000 T-SQL Problem in converting float to varchar RE: Problem in converting float to varchar

  • 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