We have a stored procedure that returns a rating factor like 1.45, or 3.52

This stored procedure is called from within other stored procedures on SQL 2000 and I need to get this value with a direct call to the store proc via VFP 6.0.

Here is my code:

lnPip = 0.00
lcSQL = [EXEC rtSearchExactflt 1, 'CALCFACT', 'CA', 'OTHERLIAB', 'OTHER', '', @lnPip OUTPUT ] 
lnResult = SQLEXEC(lnHandle, lcSQL)

Then I tried this at the suggestion of our DBA

lcSQL = [EXEC rtSearchExactflt 1, 'CALCFACT', 'CA', 'OTHERLIAB', 'OTHER', '', @lnPip OUTPUT SELECT @lnPip]

No matter what I do, I can't get the return value. If I run the command from SQL Analyzer, I get the factor immediately. How do I get it from within VFP?

Thanks in advance.