Duplicate Areas

We currently have an area called 'Vauxhall' based in SE11 and a separate wrongly spelled 'Vauxall' area based in SW8. These should be combined as one 'Vauxhall' area.

I also wondered whether it's possible to run some sort of query to tease out any other area duplication anomalies, as it's not the first I've spotted and there are bound to be others?

Quote:

---

Originally Posted by Old Blue

We currently have an area called 'Vauxhall' based in SE11 and a separate wrongly spelled 'Vauxall' area based in SW8. These should be combined as one 'Vauxhall' area.

---

Oops my fault I think, correct now I hope

Quote:

---

Originally Posted by Old Blue

We currently have an area called 'Vauxhall' based in SE11 and a separate wrongly spelled 'Vauxall' area based in SW8. These should be combined as one 'Vauxhall' area.

I also wondered whether it's possible to run some sort of query to tease out any other area duplication anomalies, as it's not the first I've spotted and there are bound to be others?

---

Ah the perennial problem for coders, the report on a thingie that looks like a thingie. Sadly a bit beyond my skill I am afraid :D