>>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.