Removing zeros from number

Question

How can I remove zeros (not just leading zeros, but zeros in every position) from a column containing Integers(numbers)?

For example : 0349010330 should become 349133

Answer 1

Here is the solution (MySQL) for Hackerrank challenge The Blunder

SELECT CEIL((AVG(salary)) - (AVG(REPLACE(salary, '0', '')))) AS avg_salary FROM employees;

• REPLACE() : used to remove 0 from salary.
• AVG() : used to calculate average salary.
• CEIL() : used to get next rounded integer.