Q&A for professional and enthusiast programmers
Select PostId As [Post Link], Score, [Text], CreationDate From Comments Where Lower([Text]) Like Lower(N'%##Text##%') Order By Score Desc, CreationDate Desc