SQL过滤空格

最新推荐文章于 2025-03-18 18:03:53 发布

aivii

最新推荐文章于 2025-03-18 18:03:53 发布

阅读量1.4k

点赞数

分类专栏： SQL_技术文章文章标签： sql go function object

本文链接：https://blog.youkuaiyun.com/aivii/article/details/1648763

版权

SQL_技术文章专栏收录该内容

5 篇文章

订阅专栏

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