UDF TRIM() Function

CREATE FUNCTION dbo.TRIM(@string VARCHAR(MAX))
RETURNS VARCHAR(MAX)
BEGIN
RETURN LTRIM(RTRIM(@string))
END
GO



SELECT dbo.TRIM(' leading trailing ')
It will return string in result window as
'leading trailing'