+1 vote

Hello everybody,

since 01/01/2019, some Flemish municipalities have merged. Here is the code to do the updates.

update [TABLE] set [CITY] = 'Aalter' where UPPER([CITY]) = UPPER('Knesselare') and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Deinze' where UPPER([CITY]) = UPPER('Nevele')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Kruisem' where UPPER([CITY]) = UPPER('Kruishoutem')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Kruisem' where UPPER([CITY]) = UPPER('Zingem')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Lievegem' where UPPER([CITY]) = UPPER('Waarschoot')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Lievegem' where UPPER([CITY]) = UPPER('Lovendegem')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Lievegem' where UPPER([CITY]) = UPPER('Zomergem')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Puurs-Sint-Amands' where UPPER([CITY]) = UPPER('Sint-Amands')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Puurs-Sint-Amands' where UPPER([CITY]) = UPPER('Puurs')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Pelt' where UPPER([CITY]) = UPPER('Overpelt')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Pelt' where UPPER([CITY]) = UPPER('Neerpelt')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Oudsbergen' where UPPER([CITY]) = UPPER('Opglabbeek')and [COUNTRY] = 25;
update [TABLE] set [CITY] = 'Oudsbergen' where UPPER([CITY]) = UPPER('Meeuwen-Gruitrode')and [COUNTRY] = 25;

Of course, you have to replace [TABLE] with the right table name, [CITY] with the correct name of the field and [COUNTRY] with the correct name of the country field.

a ++

asked in Efficy/ Client side by (103 points)
Thank you for sharing!
I believe some postcodes are also updated...

Please log in or register to answer this question.

1,169 questions
1,427 answers
1,718 comments
325 users