Óиö×Ö¶ÎAÈçÏ£º 2,3,5 44,2,445 23,22,3 Ò²¾ÍÊÇÓɶººÅ·Ö¸ôµÄÕûÊý¡£ ÎÊÌ⣺Ôõô²éѯÁ½¸ö¶ººÅÖмäµÄÊý£¿ select substring('2,3,5',charindex(',','2,3,5')+1,charindex(',','2,3,5',charindex(',','2,3,5')+1)-charindex(',','2,3,5')-1) SQL code: select parsename(replace(a,',','.'),3)+','+parsename(replace(a,',','.'),1) from (select '2,3,5' a union all select '44,2,445' union all select '23,22,3' ) b /*