SQL Server 自定义函数匹配条码规则

CREATE FUNCTION [dbo].[Fun_BarCodeCheck]
(@barcode as  varchar(120),
@rules as  varchar(120)
)
RETURNS varchar(100) AS  
BEGIN 
	declare @result as varchar(100)
	--@rules 也可以在这里定变量,可以根据,PN或材料名,站虽名等在表中查询并返回规则
	begin
		---SELECT CASE WHEN 'ABC123121BVC' LIKE 'ABC______BVC' THEN 'Match' ELSE 'No Match' END AS Result;
		set @rules=REPLACE(@rules , '%', '_')---条码规则中如果有%先替换为_
		set @result=(SELECT CASE WHEN @barcode LIKE @rules THEN 'Match' ELSE 'No Match' END AS Result)
	end
	
	return @result
END