-- SQLServer:select * from A where PATINDEX ('%[^0-9]11[^0-9]%', corpid) <= 0 and substring(corpid,1,2) != '11' and substring(corpid,len(corpid)-1,2) != '11' and PATINDEX ('%1[^0-9]%', corpid) > 0