>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.
If it's not broken, fix it until it is.
My Blog