how do I modify a string field?

[karen4201]

Let's say I have a table field that contains "Joe, Bob, Mike"
and the names might be rearranged (like "Bob, Joe, Mike"). Is there an easy way to update ALL fields that contain "Bob" so that the field would simply have Bob removed from it?

So, in essence: there is a table with a text field. Each row has many different names. I wish to remove all instances of "Bob", but keep the rest as is.

Any example code would be greatly appreciated.

Thanks in advance.

 

[DotNetGnat]

look into charindex() and patindex() functions and then you can use replace() function to replace bob with nothing...

-DNG

 

[SQLDenis]

you can use replace

declare @v varchar(666)
select @v ='Joe, Bob, Mike'

select replace(@v,'Bob,','')

but it's not perfect see below

declare @v varchar(666)
select @v ='Joe, JoeBob, Mike'

select replace(@v,'Bob,','')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/