SELECT DISTINCT vendor_city,
REGEXP_INSTR(vendor_city, ' ') AS space_index
FROM vendors
WHERE REGEXP_INSTR(vendor_city, ' ') > 0
ORDER BY vendor_city
List all Cities with 2 part names and tell me the position of the space