WHERE
userenteredcoord LIKE '%:%'
AND coordformat = 'Decimal Degrees')
</pre>
WHERE
userenteredcoord NOT LIKE '%:%'
AND (coordformat = 'Degrees:Minutes:Seconds' OR coordformat = 'Degrees:Decimal Minutes')
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]