About 1000 entries for "City" contain city names that have dashes in them.
I want to replace all dashes with spaces. How can I quickly write a query that selects all city like '%-%' and update them with a space to replace the dash? Thank you!
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.