Q&A for science fiction and fantasy enthusiasts
SELECT c.Id AS [Comment Link], c.Text, c.UserId AS [User Link], c.CreationDate FROM Comments c INNER JOIN Posts p ON c.PostId=p.Id WHERE (c.Text LIKE '%##Word1?erdos##%' COLLATE Latin1_General_CI_AI) AND (c.Text LIKE '%##Word2?probabilistc##%' COLLATE Latin1_General_CI_AI)