how to remove 0 from interger in sql code example Example: sql server remove 0 from left SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))