Author:水如烟
USE
[
LzmTW
]
GO
-- ===========================================================
-- Author: LzmTW
-- Create date: 20080110
-- Description: 确定字符串的结尾是否与指定的字符串匹配
-- ===========================================================
CREATE FUNCTION [ String ] . [ EndWith ]
(
@Value nvarchar ( max )
, @End nvarchar ( max )
)
RETURNS bit
AS
BEGIN
IF @Value IS NULL OR @End IS NULL
RETURN NULL
DECLARE
@Result bit
IF RIGHT ( @Value , [ String ] . Len ( @End )) = @End
SET @Result = 1
ELSE
SET @Result = 0
RETURN @Result
END
GO
-- ===========================================================
-- Author: LzmTW
-- Create date: 20080110
-- Description: 确定字符串的结尾是否与指定的字符串匹配
-- ===========================================================
CREATE FUNCTION [ String ] . [ EndWith ]
(
@Value nvarchar ( max )
, @End nvarchar ( max )
)
RETURNS bit
AS
BEGIN
IF @Value IS NULL OR @End IS NULL
RETURN NULL
DECLARE
@Result bit
IF RIGHT ( @Value , [ String ] . Len ( @End )) = @End
SET @Result = 1
ELSE
SET @Result = 0
RETURN @Result
END