You can try using a CTE/With clause. Failing that use a function with SELECT INTO...
On Jun 18, 2011, at 22:45, lover boi <lover-boi@live.co.uk> wrote:
> Hi,
>
> In the following statement, does the custom function get executed twice?
>
> SELECT
> MY_FUNCTION(...),
> CASE WHEN MY_FUNCTION(...) = '...' THEN '...' ELSE '...' END
> ...
> ...
>
>
> If so, is there a way I can make it execute once? I tried this but it gave me a "Column my_function does not exist"
error.
>
> SELECT
>
> MY_FUNCTION(...) AS my_function,
>
> CASE WHEN my_function = '...' THEN '...' ELSE '...' END
>
> ...
>
> ...
>
>
> Thank you in advance.