Home Forums SQL Server 2005 T-SQL (SS2K5) ltrim rtrim Causing Floating Field to Round up?? RE: ltrim rtrim Causing Floating Field to Round up??

  • October 23, 2013 at 12:00 am

    #1660795

    GilaMonster (10/22/2013)

    Why are you trimming a float in the first place?

    A float cannot have leading or trailing spaces as it's a numeric data type. Only strings can have leading or trailing spaces.

    Hi David,

    What are you trying to do with trim function on FLOAT value?