Search your own comments for a string. Results show the comment, its score, the date, and a link to the post, newest comments first.
Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
DECLARE @pattern nvarchar(100) = UPPER(##Pattern:string##)
Id AS [Comment Link],
PostId AS [Post Link]
WHERE UserId = ##UserID## AND UPPER(Text) LIKE '%' + @pattern + '%'
ORDER BY CreationDate DESC