>I am experiencing a strange problem with the following code:
>
>

>SELECT * FROM MyTable WHERE test() > 10
>
>FUNCTION test
>RETURN (MAX(MyTable.DATE1-MyTable.DATE2,0))
>

>
>The code above returns (selects) no records if the value after test() is greater than 10 (e.g. test() > 11). However, many records in the table MyTable have value of DATE1 greater than DATE2 by more than even 20.
>
>What am I missing in my sample code above?
>
>Thank you.

BTW, there was an interesting discussion on UDF in Query on the Russian forum some time ago, in which Aleksey participated. I'll check it tomorrow, if don't forget.