Mat,

Well, I figured you had just simplified it for illustrative purposes. Are you simply executing this query or are you executing a Stored Procedure? I use Stored Procs for all my data access and highly recommend this practice (though I'm sure not everyone agrees with me there).

~~Bonnie



>Bonnie,
>
>Thank you for the reply. I am using SQL Server and I had thought about your suggestion, but the calculations are more complicated than the exmaple I gave. So it would be a lot cleaner if I could use the calculated results.
>
>Kind Regards,
>
>Mat
>