Author:水如烟
USE
[
LzmTW
]
GO
-- =============================================
-- Author: LzmTW
-- Create date: 20080110
-- Description: 字符串长度,包括尾部空格
-- =============================================
CREATE FUNCTION [ String ] . [ Len ]
(
@Value nvarchar ( max )
)
RETURNS int
AS
BEGIN
IF @Value IS NULL
RETURN NULL
DECLARE
@Result int
SET @Result = LEN ( @Value + N ' @ ' ) - LEN (N ' @ ' )
RETURN @Result
END
GO
-- =============================================
-- Author: LzmTW
-- Create date: 20080110
-- Description: 字符串长度,包括尾部空格
-- =============================================
CREATE FUNCTION [ String ] . [ Len ]
(
@Value nvarchar ( max )
)
RETURNS int
AS
BEGIN
IF @Value IS NULL
RETURN NULL
DECLARE
@Result int
SET @Result = LEN ( @Value + N ' @ ' ) - LEN (N ' @ ' )
RETURN @Result
END