这样安全点
select aa=sum(case when charindex(',aa,',','+字段+',')>0 then 1 else 0 end),
bb=sum(case when charindex(',bb,',','+字段+',')>0 then 1 else 0 end),
cc=sum(case when charindex(',cc,',','+字段+',')>0 then 1 else 0 end)
from 表
select aa=sum(case when charindex('aa',字段)>0 then 1 else 0 end),
bb=sum(case when charindex('bb',字段)>0 then 1 else 0 end),
cc=sum(case when charindex('cc',字段)>0 then 1 else 0 end)
from 表