SQL Converting real to INT, is it possible?

I have got a table that has a column with real as its datatype, I am trying to update it and edit the real values to int values. Is it possible? If yes, then please give me a query because I tried a lot and the result was just an epic fail.
What I tried (Didn’t work at all)

UPDATE _Table set column = REPLACE(column,'.%','')

That query didn’t work, Is there any possible solution for my problem?
Any help would be much appreciated!

Source: sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.