if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FUNC_Trim]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[FUNC_Trim]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE FUNCTION [dbo].[FUNC_Trim]
( @Enter NVARCHAR(4000) )
RETURNS NVARCHAR(4000) AS
BEGIN
DECLARE @Str NVARCHAR(4000)
DECLARE @V NVARCHAR(1)
DECLARE @V1 NVARCHAR(4000)
IF ISNULL(@Enter,'')!=''
BEGIN
SET @Enter = RTRIM(LTRIM(@Enter))
IF LEN(@Enter) > 0
BEGIN
SET @V = SUBSTRING(@Enter,1,1)
SET @V1 = SUBSTRING(@Enter,2,LEN(@Enter)-1)
SET @Str = @V + dbo.FUNC_Trim(@V1)
END
ELSE
BEGIN
SET @Str = @Enter
END
END
ELSE
BEGIN
SET @Str = ''
END
RETURN @Str
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO