pietlinden (2/26/2015)
Task 1: Find all records that begin with 'THE '. Play with RIGHT() to strip it off.use update query to remove it from the front of the string and append it to the end.
Replace will work for this also. Basically, remove it and add it to the end.
REPLACE(Field, 'THE ', '') + ' , THE'
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/