Conversion varchar to intHi,
I have a table column varchar type, values are such 1,2.5,6.7,1.7,2.8,1.0 etc..
I want to update this round the number which are having with ".".
1.0 should be updated as 1 and 6.7 should be updated as 7 (this column is varchar data type)