Get integer part of number

t-sql

Solution

SELECT FLOOR(value)

http://msdn.microsoft.com/en-us/library/ms178531.aspx

FLOOR returns the largest integer less than or equal to the specified numeric expression.

Problem

So I have a table with numbers in decimals, say ``` id value 2323 2.43 4954 63.98 ``` And I would like to get ``` id value 2323 2 4954 63 ``` Is there a simple function in T-SQL to do that?

Original source