select * from PR_Practitioner where PracTypeCodes like '%,%,%'
查询字符串长度大于11的:
select COUNT(*) from PR_Practitioner where len(PracTypeCodes)>=11
select COUNT(*) from
(select Prac.PracId from PR_Practitioner prac,PR_PracQualification pq
where prac.PracId=pq.PracId
group by prac.PracId
having COUNT(*)>=3) A