I am looking to search for a particular email (e.g., fname@exmaple.com) in an nvarchar column in SQL Server. It should have been as easy as – However the above query is not covering one case. If the result set contains a Comment like “Comment from a user with email selfname@example.com”. In this case the above query will return both records