Author:水如烟
USE
[
LzmTW
]
GO
-- =======================================================================================
-- Author:LzmTW
-- Create date:20080111
-- Description:返回与条件相匹配的最后一个匹配字符串
-- =======================================================================================
CREATE FUNCTION [ String ] . [ FindLast ]
(
@Value nvarchar ( max )
, @Search nvarchar ( max )
, @IsVagueMode bit = 0
)
RETURNS nvarchar ( max )
AS
BEGIN
DECLARE @Result nvarchar ( max )
SELECT TOP 1 @Result = [ Catch ]
FROM [ String ] . [ IndexArray ] (
@Value
, @Search
, @IsVagueMode )
ORDER BY [ ID ] DESC
RETURN @Result
END
GO
-- =======================================================================================
-- Author:LzmTW
-- Create date:20080111
-- Description:返回与条件相匹配的最后一个匹配字符串
-- =======================================================================================
CREATE FUNCTION [ String ] . [ FindLast ]
(
@Value nvarchar ( max )
, @Search nvarchar ( max )
, @IsVagueMode bit = 0
)
RETURNS nvarchar ( max )
AS
BEGIN
DECLARE @Result nvarchar ( max )
SELECT TOP 1 @Result = [ Catch ]
FROM [ String ] . [ IndexArray ] (
@Value
, @Search
, @IsVagueMode )
ORDER BY [ ID ] DESC
RETURN @Result
END