Hi All,

I have a value that I am calculating with a UDF in a SQL statement in VFP 7. I want to use that same value, in the same statement, after it is calculated, however, it only seems to work if I create a second statement, that picks up the value.

This would not be a big deal, except that there are about 4 layers of these dependant variables, so I end up execute 5 statements, when I would really like to do it in one.

Any Ideas on How I can accomplish this in a single statment?

Thanks.

Daniel