This may or may not cover it:

BOL: Returning Data Using OUTPUT Parameters

Also from BOL: How to call stored procedures (ODBC)

BR

Peter

>Hi,
>
>Can anyone give me some sample syntax for getting a return value from a Stored procedure?
>
>I am sure that Sergey has posted similar code in the past. I am sure you need to use CALL rather than EXEC in order to get the return value. This is what I have so far and it doesn't want to play ball :-
>
>

>PRIVATE nOutVal
>nOutVal = .NULL.
>
>SQLEXEC(4, "{CALL nOutVal = Claim.dbo.RepairSP_UpdateRepairOrder 261657,5002,'',NULL,NULL}")
>

>
>Any pointers?
>
>Thanks.