I am curious to know, if there is any way to remove zeroes from numeric column without converting them into string.
You could still use replace - REPLACE(Salary, 0, '') - without explicitly converting the values but the SQL statement will still do an implicit conversion