I need to replace the : in 'My Files: username' with a - to make it 'My Files- Username'.
The column name is [name] and I have to do this for all the rows in the table where [name] like 'My Files:%'.
How can I do this? (I know I will use a cursor to extract all rows and some form of substring and charindex.)
I need a quick answer to be honest.