Hi, I just can't figure how to do this with an SQL statement.
I want to replace all the '&' with 'and' in my category titles. Example 'Sports & Recreation' becomes 'Sports and Recreation'. I need to do this because my hyperlinks to thier directorires do not recognize the &.
The part the beats me is how to find and replace only the '&' part of the title.
UPDATE lsql_Category SET Title=.................................. HELP!
I want to replace all the '&' with 'and' in my category titles. Example 'Sports & Recreation' becomes 'Sports and Recreation'. I need to do this because my hyperlinks to thier directorires do not recognize the &.
The part the beats me is how to find and replace only the '&' part of the title.
UPDATE lsql_Category SET Title=.................................. HELP!