>These two things are not equivalent as a LIKE clause
>
>

>test%               <
>test%<
>

>
>The trailing spaces are significant between the char() and the varchar() variables.

So, basically, when doing such a query from the SSMS interface, where I would go parameterized, I should always use varchar instead.