Database Toolkit, single character returned

[skh69nova]

When I run the code below it only returns the first character of the user name.  If I run in SQL manager I get the whole name.

Here is the procedure: 

[jcarmody]

I haven't used parameters in a while, but my knee-jerk reaction was to change the data type to an array of strings.

Anyway, I was feeling cute; might delete later...

[skh69nova]

As can't post code here is the command that SQL is running.
Not sure why setting to length of 1