sqlÁ½×Ö·û´®±È½Ï - MS-SQL Server / ÒÉÄÑÎÊÌâ

×Ö·û´® a='0100|0200|0311|0315|0318|0420|'
×Ö·û´® b='0111|0112|0316|0304|0522|0503|'

where b like a print '888'

aÖеÄ0100´ú±íËùÓеÄ,¼´01[0-9][0-9]

Îҵı¾·½·¨ÊÇÓÃÌæ»»¡°|¡±À´ÊµÏÖÆ´sqlÓï¾ä£¬µ«ÊÇЧÂʺܵͣ¬Çë¸÷λ¸ßÊÖ¸ø¸ö¸ßЧµÄ·½·¨£¡
 FUNCTION [dbo].[String_Rather2] --ÅжÏÀà
(
@PanString varchar(2000),--ÒªÅжϵÄÁÐ
@YuanString varchar(2000) --Òª¶Ô±ÈµÄÁÐ
)
RETURNS varchar(max)
AS
BEGIN
declare @sql varchar(max)
set @sql =char(32)+@YuanString+char(32)+'like'+char(32)+char(39)+char(37)+replace(@PanString,'|',char(37)+char(39)+char(32)+'or'+char(32)+@YuanString+char(32)+'like'+char(32)+char(39)+char(37))+'m><n'+char(37)+char(39)
RETURN @sql
END
@a=a,@b=b --µ÷ÓÃÉÏÃæµÄ·½·¨º¯Êý

set @a = replace(@a ,'000','0[0-9][0-9]')
set @a = replace(@a ,'00','[0-9][0-9]')
set @where = @where + ' and ('+dbo.String_Rather2(@a, @b)+')'

ÔÙ´ÎÇë´ó¼Ò´Í½Ì£¡£¡ÔÚÏߵȡ­¡­

---

http://blog.csdn.net/sgtzzc/archive/2009/10/15/4676777.aspx

---

ÄãÒªµÄÊÇʲôÑùµÄ½á¹û¡£¡£¡£

---

û¿´¶®,Ҫʲô½á¹û?

---

ÎÒ¾ÍÒªÒ»¸öÈç¹ûb×Ö·û´®ÊôÓÚa×Ö·û´®£¬´òÓ¡8888
0100°üÀ¨0111-0199
²»Öª¼¸Î»ÄÜÃ÷°×·ñ

---

ÒýÓÃ

ÎÒ¾ÍÒªÒ»¸öÈç¹ûb×Ö·û´®ÊôÓÚa×Ö·û´®£¬´òÓ¡8888
0100°üÀ¨0111-0199
²»Öª¼¸Î»ÄÜÃ÷°×·ñ

û¶®£¬Ö»±ÈÇ°4λÂë

---

°´¡°|¡±·Ö¸îËùÓеÄÄÇЩËÄλÊý
±ÈÈça='0100|0200|...' b='0111|6000|...'
bÖÐµÄ 0