Q&A about the site for members of the workforce navigating the professional setting
DECLARE @userid INT SET @userid = (SELECT Id FROM Users WHERE DisplayName = 'mosvy') SELECT @userid SELECT Id AS [Comment Link], CreationDate, Text FROM Comments WHERE UPPER(Text) LIKE UPPER('%##CommentText##%') AND UserId = STR(@userid) ORDER BY CreationDate DESC