SQL: Pattern Matching Issues with Unicode Datatypes
1. When defining columns to store character data in tables we can either store as ASCII characters or Unicode characters.
2. When Unicode data (nchar or nvarchar data types) are used with LIKE, trailing blanks are significant and you will need to allow for them.
Read More Here: SQL Pattern Matching