Try

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

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