SELECT substring(City, 1, CHARINDEX('-',City)-1) CityName, substring(City, CHARINDEX('-',City)+1, LEN(City)) CityLocation FROM My_Table
SELECT CASE WHEN City LIKE '%-%' THEN LEFT(City, Charindex('-', City) - 1) ELSE City END as CityName, CASE WHEN City LIKE '%-%' THEN RIGHT(City, Charindex('-', Reverse(City)) -1) END as CityLocation FROM Addresses
SELECT city, Substring(city, 1, Charindex('-', city, 1) - 1) AS col1, Substring(city, Charindex('-', city, 1)+1, Len(city)) AS col2 FROM cp_locations_D_D
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)