You have to be consistent. You can't mix nvarchar and varchar values in the column and have them work. I'm going to have to convert all data to nvarchar or varchar for this to work.