>>>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")

>
>I'm sorry, that didn't help. I must be missing something.

What's the problem? Anyway, the parameter in SP should be marked as output.

CREATE PROCEDURE sp_name @par1 varchar(200) OUTPUT
AS
...
SET @par1 = "My Return String"
...