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

Well, I don't see what I did wrong. I started with your SP and cut and paste my code into it and it works. Obviously I'm missing something but it works now and that's what counts.

thank you.