Q&A for computer enthusiasts and power users
SELECT postid, postid [Post Link], text FROM comments WHERE ( Upper(text) LIKE Upper('%##UserName##%') AND Charindex('@', text) = 0 )