SQL查询问题？ - MS-SQL Server / 基础类

有个字段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
/*

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2,5
44,445
23,3

(3 行受影响)


*/

---

引用

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
/*

---------------------……

应该只要parsename(replace(a,',','.'),2)

---

引用

引用 2 楼 beirut 的回复:
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'