sql 字符串长度

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