There's no built-in function that does that. However...
Itzik, in his PASS precon, showed a cool trick for faking one using some highschool maths.
LOGx(a * b * c) = LOGx(a) + LOGx(b) + LOGx(c)
So...
DECLARE @test-2 TABLE (val int)
INSERT INTO @test-2 VALUES (1)
INSERT INTO @test-2 VALUES (2)
INSERT INTO @test-2 VALUES (3)
INSERT INTO @test-2 VALUES (4)
INSERT INTO @test-2 VALUES (5)
SELECT
POWER(10., SUM(LOG10(val)))
FROM @test-2
Result: 120
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability