select (SELECT count(id)
FROM Lc_NewsInfo
where (Title+Querytitle) like '%' + @key +'%')
+
(SELECT count(id)
FROM Lc_NewsInfo
where Context like '%' + @key +'%')
FROM Lc_NewsInfo
where (Title+Querytitle) like '%' + @key +'%')
+
(SELECT count(id)
FROM Lc_NewsInfo
where Context like '%' + @key +'%')
http://community.csdn.net/Expert/topic/3324/3324468.xml?temp=.1988489
where (charindex(@key,Title)>0
or charindex(@key,Querytext)>0
or charindex(@key,Context)>0)
and DelFlag = 1