I use both ssms and the app is an report which I make using visual studio 2005. Visual studio is a little slower in showing the data than ssms. But both...

To answer your questions best I can.

Yes I'm sure to column is varchar(8) and no the query plan is not changing much. I have no index on that column....