Hi-

I need to change part of the name on all of my several hundred categories, and I've been trying to do it through an SQL command, but have had no luck. Does anyone know if it's possible to replace the string "xyz" in the Category table Name field with "abc" through an SQL command?

I tried:

Update Category
REPLACE (Name, 'xyz', 'abc')

But that doesn't seem to work. If anyone has any ideas, they would be greatly appreciated!

-FrankM

UPDATE Category SET Name = REPLACE (Name, 'xyz', 'abc')

Paul,

Thanks very much, that worked perfectly. I appreciate your help.

--FrankM