I have a varchar column that has numbers with .0
This column has both numeric data and non-numeric data.
I first tried to convert data type to integer, but since there is non-numeric data type, it would not let me.
How do I remove .0?
So, for example, 100.0 should be 100
Read more here: https://stackoverflow.com/questions/68459955/replace-0-on-varchar-data-type
This content was originally published by Java at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.