Export (0) Print
Expand All
Expand Minimize

LOG10 (SQL Server Compact)

Returns the base-10 logarithm of the given float expression.


LOG10 (float_expression )

float_expression

An expression of the type float, or of types that can be implicitly converted to float.

The following example returns the base-10 logarithm of various float values.

CREATE TABLE [Base-10 Logarithms] ([LOG10 2] float, [LOG10 20] float, [LOG10 200] float);
INSERT INTO [Base-10 Logarithms]
                         ([LOG10 2], [LOG10 20], [LOG10 200])
VALUES        (LOG10(2), LOG10(20), LOG10(200));
SELECT        [LOG10 2], [LOG10 20], [LOG10 200]
FROM            [Base-10 Logarithms];
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft