I will give that a try - thanks for the help/

A

"subtenante" <zzsubtenantezz@gmail.com> wrote in message
news:0nng43l5foson5o6te52ilclc4r6q9p8bd@4ax.com...
> 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-%';