NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
These two queries finds MGRS coordinates where the format is incorrect<pre>SELECT geopoint.userenteredcoord,
concat( upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1)),right(geopoint.userenteredcoord,7))
FROM
