SELECT count(*)  as nbr_of_parts_with_leading_zeros 
  FROM table
  WHERE part like '0000000%';