A function used in select clause and where clause.

I am building a query that uses a function I wrote. It does something similar to the following:

select MYFUNCTION(SALARY)
from EMPLOYEES
where MYFUNCTION(SALARY) > 100000;

My question is: does the MYFUNCTION(SALARY) get executed twice? If so, how can I rewrite this query to avoid that?

Anyones help would be appreciated and thanks in advance. Michael Swart Received on Fri Jun 06 2003 - 19:52:32 CEST