Point ID Length

This query groups PointID on LENGTH. If length is 0, 1, or 2 the values should be looked into

SELECT
Count(geopoint_guid),
length(trim(pointlocal_id))
FROM
geopoint
GROUP BY
length(trim(pointlocal_id))
ORDER by length(trim(pointlocal_id))

This query checks the Point ID with length 2

SELECT DISTINCT
trim(pointlocal_id)
FROM
geopoint
where length(trim(pointlocal_id) )= 2
ORDER by pointlocal_id