Sure:

CREATE PROCEDURE p_procname
    @ntest INTEGER OUTPUT
AS
    SET @ntest = @ntest * 2

---

>Could you post the code of your stored proc....???
>
>
>>Hi John,
>>
>>Can the output from a SP be captured in VFP? I made a few tries but I can't make it work:
>>
>>x = 20
>>SQLEXEC(nConn, "EXEC p_procname ?x OUTPUT")