Use percents in your search string if you want wildcards: %foo%
Q&A for professional and enthusiast programmers
SELECT Comments.CreationDate, Comments.Id as [Comment Link] FROM Comments WHERE Comments.UserId = ##UserId?117549## and Comments.Text LIKE ##needle:string## ORDER BY Comments.CreationDate DESC