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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham