>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

Yep...it is well know that if your program name is the same as the function name, removing the function/procedure statement from the program grealtly increses performance.

BOb