locate('|', geopoint.userenteredcoord) -1) <> upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1))
ORDER BY length(geopoint.userenteredcoord)
Note: This query is in 5.x format
---------------------------------------------------
ORDER BY
user_entered_mgrs ASC
Note: This query is in 5.x format
</pre>
[[Category:NoPublic]]