CREATE FUNCTION dbo.Trim
(
   @string nvarchar(max)
)
RETURNS nvarchar(max)
AS
BEGIN
   RETURN LTRIM(RTRIM(@string))
END

Today I need Trim() function in sql, but in Sql 2005 there is no function. Because of that I wrote this user (scalar) fuction.
It's very basic;
-First; it's Right Trim (RTrim()) string 
- And then Left Trim (LTrim())

SQL Trim Function

sql

SQL