SQL + udf's Where is it cool & where not?

I'm at work now & I don't have my dev env. Where is it ok to use a udf in a
vfp sql statement & where not. I seem to remember in the Select clause is a
no-no, but in the where clause is ok.

Dan
Wed Mar 19 15:59:28 CDT 2008

The only problem in WHERE is that it can't be optimized.

Careful in the output list -- it must return a fixed-length value.

Dan

Lew wrote:
> I'm at work now & I don't have my dev env. Where is it ok to use a
> udf in a vfp sql statement & where not. I seem to remember in the
> Select clause is a no-no, but in the where clause is ok.

Sergey
Thu Mar 20 08:10:55 CDT 2008

Lew wrote:
> I'm at work now & I don't have my dev env. Where is it ok to use a udf in a
> vfp sql statement & where not. I seem to remember in the Select clause is a
> no-no, but in the where clause is ok.

An UDF will slow a query significantly in either place.

--
--sb--

VFP MVP