remove decimal points from a column value.

Question

I have a requirement in which a column in the table should have distinct values but it may have multiple null values. How can I achieve that?

Answer 1

CREATE TABLE TableDecimal (Value DECIMAL(24,21))
INSERT TableDecimal (Value) VALUES (2)
INSERT TableDecimal (Value) VALUES (3.00000000000000000000)
SELECT Value FROM TableDecimal
SELECT CAST(Value AS INT) AS Value_to_int FROM TableDecimal
SELECT CAST(Value AS DECIMAL(24,0)) AS Value_to_Decimal0 FROM TableDecimal
GO
DROP TABLE TableDecimal
GO