sql server remove zeroz from number code example

Example: eliminate zero from integer mysql

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