I have a UDF that is used in an SQL Select that is basically the following:

X.PRG
-----
FUNCTION X

PARAMETERS Y

(CODE)

RETURN (Z)
-----

The Select calls this UDF in the Where clause ( WHERE X(Table.Field) <= Value ). I've notice a dramatic increase in performance by removing the "FUNCTION X" statement in the .PRG file. Is this expected?

Thanks,
Jonathan