how to remove zeros from a number in sql code example

Example: eliminate zero from integer mysql

REPLACE('0349010330', '0', '');