Q&A about the site for expert genealogists and people interested in genealogy or family history
--DECLARE @CommentText nvarchar(600) = ##CommentText:string## --SELECT @CommentText = UPPER(@CommentText) SELECT PostId AS [Post Link], Score AS [Score], Id AS [Comment Link], CreationDate AS [Creation Date] FROM Comments WHERE UserId = 153512 --AND UPPER(Text) LIKE '%' + @CommentText + '%' ORDER BY CreationDate DESC