<pre>SELECT geopoint.userenteredcoord, concat( upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1)),right(geopoint.userenteredcoord,7))
FROM
geopoint
WHERE
geopoint.coordrefsys = 'MGRS' AND
binary left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1) <> upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1))
ORDER BY length(geopoint.userenteredcoord)
SELECT
user_entered_mgrs
FROM
geopoint
WHERE
coordrefsys = 'MGRS' AND user_entered_mgrs LIKE '% %'
ORDER BY
user_entered_mgrs ASC
</pre>
[[Category:NoPublic]]