Truncate (not round) decimal places in SQL Server?

Question

I'm trying to determine the best way to truncate or drop extra decimal places in SQL without rounding. For example: declare @value decimal(18,2) set @value = 123.456 This will auto round @Value to be 123.46....which in most cases is good. However, for this project I don't need that. Is there a simple way to truncate the decimals I don't need? I know I can use the left() function and convert back to a decimal...any other ways?

Answer 1

You can use the Round() function to perform either rounding or truncation. The function takes 3 arguments: The number to be rounded/truncated, the number of decimal places you want in the result, and an indicator to perform rounding or truncation. To get truncation, specify a value other than 0 in the 3rd argument.

Example:

SELECT ROUND(99.476, 2, 1)