Q&A for professional and enthusiast programmers
SELECT c.Text AS "Comment", c.CreationDate AS "Comment Date", u.DisplayName AS "User Name", c.PostId AS [Post Link] FROM Comments c JOIN Users u ON u.Id = c.UserId WHERE c.Text LIKE '%##searchString1##%'