Q&A for professional and enthusiast programmers
select Comment.Id as [Comment Link], Comment.Score as [Score] from Comments as Comment left join Posts as Post on Post.Id = Comment.PostId where UPPER(Text) LIKE UPPER('%##CommentText##%') AND UserId = '##UserId##'