Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
SELECT TOP 100 ISNUMERIC(CHARINDEX(',', REVERSE(Location))+2)[country], Location[City] FROM Users WHERE Location IS NOT NULL;