sqlserver查找指定字符串的个数

select  top 10 [title] 
,[authors]

--查找指定字符串的个数，name长度4；要除以4才可以得到个数
,(LEN([authors])-LEN(replace([authors],'name','')))/4  as authorCount  

from  [Bus_InformationInfo]
order by  authorCount desc