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