• 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass