A lexical search method
Q&A for SharePoint enthusiasts
-- Finding bad answers through comments -- A lexical search method SELECT TOP 1000 c.PostId AS [Post Link], YEAR(C.CreationDate) AS Year, Month(C.CreationDate) AS Month, c.text AS Body FROM Comments C, Posts P Where ( C.Text LIKE '%not an answer%' AND C.PostID = P.ID AND P.ClosedDate IS NULL AND P.PostTypeId = 2 AND P.Score <= 1 ) Order By Year, Month