Hi Dorin

>You can use

>FOR SELECT ... INTO ... DO BEGIN
>    ...statements or another FOR SELECT INTO
>END

>in stored procedures with input and output parameters to process rows as in VFP SCAN/ENDSCAN and in the same time return rows to client.
>
>You can even dynamically construct those SELECT statements based on table names passed as parameters and then use
>

FOR EXECUTE STATEMENT {cDynamicSQL} INTO ... DO BEGIN
>    ...statements or another FOR SELECT INTO
>END
>

Whoa, this is heavy for me <g>. Nay, I was just curious if I could send parameters and receive one value back for the select statement use, like we do for select's in VFP, something like:

SELECT MyUDF(t.Val1, t.Val2) AS RetValFld FROM MyDBF t ....

FUNCTION MyUDF
   LPARAMETERS tnV1, tnV2

   ... lot of stuff here

   RETURN lnRetVal
ENDFUNC

I just want to shift the CASE into the Stored Procedures (one for the Dr and other for Cr side) which will expect 2 values do this same CASE inside and return the end result that we already have. As this CASE will remain standard, I believe, for this and other table that I will be later adding.