0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for legal professionals, students, and others with experience or interest in law

SELECT Posts.Id AS [Post Link], PostTypes.Name, Users.DisplayName 
  FROM Comments INNER JOIN Posts ON Comments.PostId=Posts.Id INNER JOIN PostTypes ON Posts.PostTypeId=PostTypes.Id INNER JOIN Users ON Posts.OwnerUserId=Users.Id
 WHERE UPPER(Text) LIKE UPPER('%##CommentText##%')
   AND UserId = '##UserId##'

fork query

edited sep 25 19 Dale.Morrell

created dec 5 13 hims056