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 6, 2009 at 8:16 am

    #1049856

    select rtrim(ltrim(replace(replace('z z',' ',''),' ','')))

    zz Instead of z z