Alert on any POTA Park in a specific state or country

Something like

SELECT *
FROM SPOTS
WHERE STATE = ‘RI’
AND TRIM(POTA) <> ‘’;

Or even better would be

SELECT *

FROM SPOTS

WHERE UPPER(STATE) IN (‘RI’, ‘AK’, ‘HI’)

AND TRIM(POTA) <> ‘’;

@NY9K I’ll add this as a feature request.

1 Like