Michel,
I'd say it depends entirely on the underlying column datatype, and whether or not it's being used as a LIKE clause.
>So, basically, when doing such a query from the SSMS interface, where I would go parameterized, I should always use varchar instead.