Q&A about the site for science fiction and fantasy enthusiasts
DECLARE @SearchText VARCHAR(100) = ##SearchText:string## DECLARE @OnlyBeginning BIT = ##OnlyBeginning:int## DECLARE @After DATETIME = ##After:string## SELECT TOP 100 Id, Id AS [Post Link], CreationDate, Body FROM Posts WHERE PostTypeId = 2 AND ( (@OnlyBeginning = 1 AND Body LIKE '<p>' + @SearchText + '%') OR (@OnlyBeginning = 0 AND Body LIKE '%' + @SearchText + '%') ) AND (CreationDate > @After) ORDER BY CreationDate DESC