Multiplication Aggregate

Hi,
Is there an equivalent to the SUM() aggregate function but instead of doing
a summation, I'd like to do a mulitiplication. Is there a way to achieve this?
Please help. Thanks!Sorry, no such thing as SUMPRODUCT() in SQL Server as there is in Excel.
GeoSynch
"ddinulos" <ddinulos@.discussions.microsoft.com> wrote in message
news:AF5F584D-A464-4658-901A-F435A7246B19@.microsoft.com...
> Hi,
> Is there an equivalent to the SUM() aggregate function but instead of doing
> a summation, I'd like to do a mulitiplication. Is there a way to achieve this?
> Please help. Thanks!
>