SQL SERVER - TRIM() Function

CREATE FUNCTION dbo.TRIM(@string VARCHAR(MAX))
RETURNS VARCHAR(MAX)
  BEGIN
  RETURN LTRIM(RTRIM(REPLACE(@string,CHAR(9),'')))
  END
GO

CHAR(9)   = TAB
CHAR(10)  = Line Feed
CHAR(13) = Carriage Return

This function also trims TABs, you can add
Line Feed and Carriage Return replacement,
if it is needed.