replace text

Greetings.

I can't figure out how to use replace.. maybe I'm looking at it wrong.

I need to replace all occurrences of 'abc1' with 'abc2' in columns fitting a where clause (like this I imagine for table 'myAttributes': replace ('abc1','abc2) in myAttributes where column1 = 'mycolumn1' and column2 = 'mycolumn2')

Can someone tell me the right way to do this?

Thanks
Jeff Kish Received on Fri Mar 05 2004 - 16:52:37 CST