6

Please login or register to vote for this query.

(click on this box to dismiss)

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 professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

DECLARE @pattern nvarchar(100) = UPPER(##Pattern:string##)

SELECT
    Id AS [Comment Link],
    Score,
    CreationDate,
    PostId AS [Post Link]
FROM Comments    
WHERE UserId = ##UserID## AND UPPER(Text) LIKE '%' + @pattern + '%'
ORDER BY CreationDate DESC

fork query

edited aug 11 12

created aug 11 12 Brad Mace