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!