Rev 5 | Blame | Compare with Previous | Last modification | View Log | RSS feed
select COMMUNE_NOM, reverse(substring(reverse(COMMUNE_CODEPOSTAL),4,2)), '', COMMUNE_LATITUDE , COMMUNE_LONGITUDE , COMMUNE_ALTITUDE from COMMUNE