replace .0 on varchar data type

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

enter image description here

Read more here:

Content Attribution

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.

%d bloggers like this: