MySql adding leading sign’s to coloumns

SELECT LPAD('1101', 8, '0');

and to remove them:

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