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