>I have a store procedure that needs to return a character string. I have the string store in a local variable on SQL and I am running the stored procedure via SQLEXECUTE.
>
>What are my return options from SQL? Is there a way to catch a Print output from a Stored Procedure?
>
>Thank you in advance.
You can return cursor with one field or you can use output parameter
lcRetVal = ""
= SQLExec(lnHandle,"EXEC sp_name ?@lcRetVal")
--sb--