采用
select distinct * from table where methods like '%AddRegion%'
得到结果
AddRegion
AddRegion,entExtrude3D
AddRegion,entRevolve3D
AddRegion,entRotate3D
AddRegion1
AddRegion1,entRotate3D
AddRegion2
AddRegion2,entRevolve3D
目标需求只要AddRegion1
AddRegion2" where methods = 'AddRegion1' or methods = 'AddRegion2'"目标可以实现
可是AddRegion1---AddRegion(N个),采用手动控制,不可操作.
where methods like "%AddRegion" 结果只有AddRegion
请问,各位大侠,where如何处理, AddRegion & n个数字.
实现目标为
AddRegion1
AddRegion2
select distinct * from table where methods like '%AddRegion%'
得到结果
AddRegion
AddRegion,entExtrude3D
AddRegion,entRevolve3D
AddRegion,entRotate3D
AddRegion1
AddRegion1,entRotate3D
AddRegion2
AddRegion2,entRevolve3D
目标需求只要AddRegion1
AddRegion2" where methods = 'AddRegion1' or methods = 'AddRegion2'"目标可以实现
可是AddRegion1---AddRegion(N个),采用手动控制,不可操作.
where methods like "%AddRegion" 结果只有AddRegion
请问,各位大侠,where如何处理, AddRegion & n个数字.
实现目标为
AddRegion1
AddRegion2
whereStr = " where methods = 'AddRegion1' or methods = 'AddRegion2' or methods = 'AddRegion3' or methods = 'AddRegion4'"
用n个AddRegion(n)来解决.
此方法太笨,想不出来别的方法.
from table
where methods in ('AddRegion1','AddRegion2')
where isnumeric(right(methods,len(methods)-9))=1
目标实现
AddRegion(n),n最多只到6,AddRegion6最多了.
AddRegion10和AddRegion11以上的数据不会用的.
For kk1 = 2 To 6
whereStr3 = whereStr3 & "or methods = 'AddRegion" & kk1 & "'"
Next kk1
whereStr3 = whereStr3 & ")"
再用循环法也不如各位大侠的招高.谢谢各位大侠的指教.