You could use the REPLACE function.

As a safeguard make a new column on your table and run this statement....

UPDATE mpTable SET myNewColumn = REPLACE(myOriginalColumn, 'A\BO', 'A\C-B0')

If it works good, you may be able to then use "SET myOriginalColumn" and
remove the new column. May need tweaked, but see what happens?



--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz


"Guinness Mann" <GMann@dublin.com> wrote in message
news:MPG.1a22a815a633b89898972a@news.newsguy.com.. .
> I have a column in one of my tables that needs to have about half of its
> values updated.
>
> The data looks like this:
>
> A\B0andSomeVaryingStuff.mp3
>
> I'd like to update it to:
>
> A\C-B0andSomeVaryingStuff.mp3
>
> The A, \-sign, B, C, .mp3 and - are literals. The
> "andSomeVaryingStuff" changes. All I want to do is to replace the \B
> with \C-B.
>
> So I need to say "Find the instances where there is an A\B0 and replace
> the A\B0 with A\C-B0 leaving the andSomeVaryingStuff.mp3 the same."
>
> Note that every row will not need to be updated -- only the ones where
> the column data begins A\B0.
>
> Can you help?
>
> Thank you,
>
> -- Rick