Remove decimal values using SQL query

Question

I am having following values in database table :

12.00
15.00
18.00
20.00

I want to remove all decimal ZEROS from all values , So how can I do this using SQL query. I tried replace query but that is not working.

I want values like :

12
15
18
20

My replace query :

       select height(replace (12.00, '')) from table;

Please help.

Answer 1

Since all your values end with ".00", there will be no rounding issues, this will work

SELECT CAST(columnname AS INT) AS columnname from tablename

to update

UPDATE tablename
SET columnname = CAST(columnname AS INT)
WHERE .....