Comparing Strings in SQL Server
If you are trying to compare two strings in a stored procedure or trigger or … you need to note that you have to specify the length of the strings before comparison, if you don’t do that, you won’t get the expected result out of your query. Also remember, it is one equal sign not…