departement 2BSELECT UPPER(TRIM(ville)) as ville, cp FROM job_resume WHERE departement="2B" OR LEFT(cp, 2)=LEFT("2B", 2) OR LEFT(cp, 3)=LEFT("2B", 3) GROUP BY UPPER(TRIM(ville)) ORDER BY UPPER(TRIM(ville)) ASC