On Mon, 14 May 2007 08:02:29 -0500, "Auddog" <will_k@hotmail.com>
wrote:

>Is there a way to update just a portion of some data. I have a entry field
>for serial numbers, but a new user entered the wrong serial numbers for a
>couple hundred serial numbers. She entered AXO-xxxx instead of AX0-xxxx. I
>would like to keep the existing numbers, but would like to update the
>AXO-xxxx to AX0-xxxx. Thanks for any help you can provide.
>
>A
>

Something like :

UPDATE table
SET serial=CONCAT('AX0-',SUBSTRING(serial,5))
WHERE serial LIKE 'AXO-%';