SQL SERVER 正则匹配实例分享--【叶子】

create function dbo.RegexMatch  
(  
    @pattern varchar(2000),  
    @matchstring varchar(8000)  
)  
returns int  
as   
begin  
    declare @objRegexExp int  
    declare @strErrorMessage varchar(255)  
    declare @hr int,@match bit  
    exec @hr= sp_OACreate 'VBScript.RegExp', @objRegexExp out  
    if @hr = 0   
        exec @hr= sp_OASetProperty @objRegexExp, 'Pattern', @pattern  
    if @hr = 0   
        exec @hr= sp_OASetProperty @objRegexExp, 'IgnoreCase', 1  
    if @hr = 0   
        exec @hr= sp_OAMethod @objRegexExp, 'Test', @match OUT, @matchstring  
    if @hr <>0   
    begin  
        return null  
    end  
    exec sp_OADestroy @objRegexExp  
    return @match  
END

exec sp_configure 'show advanced option',1;
RECONFIGURE;
exec sp_configure 'Ole Automation Procedures', 1;
RECONFIGURE;

原文地址：http://blog.csdn.net/maco_wang/article/details/7439560