Answers for "how to remove 0 from integer in sql"

eliminate zero from integer mysql

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

Posted by: Guest on March-17-2020

sql server remove 0 from left

SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))

Posted by: Guest on April-23-2021

Code answers related to "how to remove 0 from integer in sql"