select sum(len(ProblemNumbers)-len(replace(ProblemNumbers,',',''))) from mytable
更正: select sum(len(ProblemNumbers)-len(replace(ProblemNumbers,',',''))+1) from mytable--测试 select sum(len(ProblemNumbers)-len(replace(ProblemNumbers,',',''))+1) from ( select 1 as ID, '4,5,6' as ProblemNumbers union all select 2, '10,12' union all select 3 , '7,8,9,10' union all select 4 , '12,15' ) as t--结果
select sum(len(ProblemNumbers)-len(replace(ProblemNumbers,',',''))+1) from mytable--测试
select sum(len(ProblemNumbers)-len(replace(ProblemNumbers,',',''))+1) from
(
select 1 as ID, '4,5,6' as ProblemNumbers
union all select
2, '10,12'
union all select
3 , '7,8,9,10'
union all select
4 , '12,15'
) as t--结果
-----------
11(所影响的行数为 1 行)
然后sum(ProblemNumbers).
select sum(len(replace(ProblemNumbers,',',,'))-len(ProblemNumbers)+1) from mytable
select sum(len(replace(ProblemNumbers,',',',,'))-len(ProblemNumbers)+1) from mytable