>The problem is that I need to run the check with case insensitivity and I need an exact match like the following:

SQL Server comes set up default to ignore case sensitivity. And if you use '=' instead of 'like' you should be ok with the exact matching.