That would be true if the parameter was actually there in the sql string result from the immediate window. However, since he's setting a string variable and then setting the string variable as the command text to his sql command object, the parameter value should be populated when he types in ?sql in the immediate window.

Always is for me, it's how I debug parameterized queries when I'm having issues.