Home Forums SQL Server 2005 T-SQL (SS2K5) ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING... RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

  • September 4, 2009 at 9:02 am

    #1049450

    For that given string, this worked for me:

    select rtrim(ltrim(replace(replace(@string,' ',''),' ','')))