SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
-- =============================================
-- Author:      Insus.NET
-- Create date: 2019-05-25
-- Update date: 2019-05-25
-- Description: 获取字符串尾部空格长度
-- =============================================
CREATE FUNCTION [dbo].[svf_SpaceCharacterLenthOfStringSuffix]
( 
    @string NVARCHAR(MAX) 
)
RETURNS INT
AS
BEGIN    
    DECLARE @ltrim_str NVARCHAR(MAX) = LTRIM(@string)
    RETURN LEN(REVERSE(@ltrim_str)) - LEN(@ltrim_str)
END

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
-- =============================================
-- Author:      Insus.NET
-- Create date: 2019-05-25
-- Update date: 2019-05-25
-- Description: 获取字符串长度包含头尾所有空格长度
-- =============================================
CREATE FUNCTION [dbo].[svf_StringLength]
( 
    @string NVARCHAR(MAX) 
)
RETURNS INT
AS
BEGIN    
    DECLARE @ltrim_str NVARCHAR(MAX) = LTRIM(@string)
    RETURN LEN(@string) + LEN(REVERSE(@ltrim_str)) - LEN(@ltrim_str)
END