ProgrammingMySql adding leading sign’s to coloumns by Mike • 11/02/2014 • 0 Comments SELECT LPAD('1101', 8, '0');and to remove them:SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))