remove 0 from number sql code example
Example 1: eliminate zero from integer mysql
REPLACE('0349010330', '0', '');Example 2: sql server remove 0 from left
SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))REPLACE('0349010330', '0', '');SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))