Hi Set !

Svein Erling Tysvær wrote:

>Note, I have no idea whether CASE can be used like this as part of a
>calculation, or whether you have to do the entire calculation within
>the THEN and ELSE part.
>
>HTH,
>Set
>
>

Yes, you can use CASE or COALESCE inside SUM or other agregate function.

I see CASE os COALESCE as a "function" so it just returns a value that
could be used anywhere (AFAIK).

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br