>Don't forget about the ADO Command Object - which by far - is a better way of
>working with SP's. SPT requires you to conconcatenate a string if parameters
>are involved.
Unless I'm confused (always a possibility), can't you just do:
lcParm1 = "fred"
lcParm2 = SPACE(200)
=SQLEXEC("exec sp_myProc ?lcParm1, ?@lcParm2")
?