declare @title varchar(100)
set @title='my test csdn,where test abc'
SELECT keycount=(len(@title)-len(replace(@title,'test','')))/len('test')
declare @title varchar(100)
set @title='my test csdn,where test abc'
SELECT keycount=(len(@title)-len(replace(@title,'test','')))/len('test')