Truncate (not round) decimal places in SQL Server

by 
ROUND ( 123.456 , 2 , 1 )

When the third parameter != 0 it truncates rather than rounds

http://msdn.microsoft.com/en-us/library/ms175003(SQL.90).aspx

Syntax

ROUND ( numeric_expression , length [ ,function ] )

Arguments

  • numeric_expression
    Is an expression of the exact numeric or approximate numeric data
    type category, except for the bit data type.

  • length
    Is the precision to which numeric_expression is to be rounded. length must be an expression of type tinyint, smallint, or int. When length is a positive number, numeric_expression is rounded to the number of decimal positions specified by length. When length is a negative number, numeric_expression is rounded on the left side of the decimal point, as specified by length.

  • function
    Is the type of operation to perform. function must be tinyint, smallint, or int. When function is omitted or has a value of 0 (default), numeric_expression is rounded. When a value other than 0 is specified, numeric_expression is truncated.

More Related Contents:

  1. SQL query for display one field only once which having multiple record
  2. NULL values inside NOT IN clause
  3. Exclude a column using SELECT * [except columnA] FROM tableA?
  4. SQL MAX of multiple columns?
  5. Conditional WHERE clause in SQL Server
  6. How do I create a comma-separated list using a SQL query?
  7. How to Join to first row
  8. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  9. How to calculate percentage with a SQL statement
  10. A table name as a variable
  11. Concatenate row values T-SQL
  12. Is the NOLOCK (Sql Server hint) bad practice?
  13. Creating an index on a table variable
  14. SQL – Subtracting a depleting value from rows
  15. Parse comma-separated string to make IN List of strings in the Where clause
  16. How to set variable from a SQL query?
  17. SELECT FOR UPDATE with SQL Server
  18. Compare DATETIME and DATE ignoring time portion
  19. How to group by month from Date field using sql
  20. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  21. T-SQL How to create tables dynamically in stored procedures?
  22. What is the equivalent of ‘describe table’ in SQL Server?
  23. Curly braces in T-SQL
  24. OPENXML with xmlns:dt
  25. Find min and max for subsets of consecutive rows – gaps and islands
  26. Update query using Subquery in Sql Server
  27. T-SQL: checking for email format
  28. Cumulative Total in MS Sql server [duplicate]
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment