Get integer part of number

Question

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?

Answer 1

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.

Answer 2

Assuming you are OK with truncation of the decimal part you can do: SELECT Id, CAST(value AS INT) INTO IntegerTable FROM NumericTable