SELECT RIGHT(Location, (CHARINDEX(',', REVERSE(Location)+...

0

Please login or register to vote for this query.

(click on this box to dismiss)

CiviCRM

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT
RIGHT(Location, (CHARINDEX(',', REVERSE(Location)+' ,'))) AS Location
FROM Users
WHERE Location IS NOT NULL

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results