In SQL no any TRIM function, it content LTRIM and RTRIM. so i created user function it called TRIM(<string>) for us for get trim string.

SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
CREATE FUNCTION [dbo].[TRIM](@string VARCHAR(MAX))
 RETURNS VARCHAR(MAX)
 BEGIN
RETURN LTRIM(RTRIM(@string))
 END