Here's what I want to do.
i have a table with multiple columns and in column B i have a list of names seperated by ^s
Here is a sample of records:
I want to write a script that will look within column B and if it finds the name 'Bill' it will replace it with 'William'.
So the above sample of records would become:
Any one have any idea how to do this?
There are several records and several orders in which the names could appear and I do not want to write multiple UPDATE scripts....I just want a 'find & replace' feature for within a column within and SQL table.
It HAS to be possible!!!
Thanks
i have a table with multiple columns and in column B i have a list of names seperated by ^s
Here is a sample of records:
Code:
1 Bill^Sue^Bob^Frank^
2 Fred^Joe^Bill^John^Sue^Doug^
3 Joe^Sam^Todd^
4 Bill^
I want to write a script that will look within column B and if it finds the name 'Bill' it will replace it with 'William'.
So the above sample of records would become:
Code:
1 William^Sue^Bob^Frank^
2 Fred^Joe^William^John^Sue^Doug^
3 Joe^Sam^Todd^
4 William^
Any one have any idea how to do this?
There are several records and several orders in which the names could appear and I do not want to write multiple UPDATE scripts....I just want a 'find & replace' feature for within a column within and SQL table.
It HAS to be possible!!!
Thanks