What is the exact code you use on management studio to put nvarchar-varchar states in one @variable using "IN" and is working for you?
Oh, JMC beat me to it.