Transact-SQL Reference
LOG10
Returns the base-10 logarithm of the given float expression.
Syntax
LOG10 ( float_expression )
Arguments
float_expression
Is an expression of the float data type.
Return Types
float
Examples
This example calculates the LOG10 of the given variable.
DECLARE @var float
SET @var = 145.175643
SELECT 'The LOG10 of the variable is: ' + CONVERT(varchar,LOG10(@var))
GO
Here is the result set:
The LOG10 of the variable is: 2.16189
(1 row(s) affected)