Truncate decimal value but not round off the value in SQL Server?

Answer 1

use round something like
round(123.102, 2, 1) which will just truncate but will not round off.

Hope this helps.