a.xm,xk=substring(a.xk,b.number,charindex(',',a.xk+',',b.number)-b.number) from表A a join master..spt_values bON b.type='p' AND b.number BETWEEN 1 AND LEN(a.xk)wheresubstring(','+a.xk,b.number,1)=','