Remove Decimal Places

[MsMope]

Good Morning,
I have a table that has a column "price" this column needs to be whole number only ( integers) currently, there are some values that have decimals. How do I remove these?

 

[SQLSister]

Depends on whether you want to remove them entirely or round them to the next highest or lowest value.

 

[MsMope]

I want to round up to the next highest value, but I do not want the decimal places in the table at all...

Thanks for your help

 

[bdreed35]

Try this:

SELECT CAST((ROUND(price,0,1) + 1) as int)
FROM table

~Brian

 

[checkai]

update table
set price = convert(int,round(price,0))


then update the table column to an int...

dlc

 

[SQLSister]

If you always want to round up, neither of those methods will work.

Update table
set field = Round(Field, 0, 1) +1
where field <> Round(Field, 0, 1)