>>>did they replace goto with try/catch in t-sql or you are talking about writing sprocs in vb/c#?
>>
>>try endtry catch
>>
>>>im doing most of the work in oracle/pl-sql and i like this language much better than t-sql.
>>
>>sql2005's t-sql reduce the gap, but p-sql is some years ahead.
>
>How do you return Return code into VFP from SP?
>
>Thanks.

DECLARE @return INT

EXEC @return=[db].[user].[procedure]

SELECT @return