SQL过滤空格

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