Hi.

I'm getting an error when I try to run the following query in MySQL:

UPDATE gtbl_Direct
SET strCustomerID=Concat('D0', Right(strCustomerID,6))
WHERE Length(strCustomerID)=7;

What I'm trying to do is change existing 7 character values to 8
characters by adding a zero. E.g.,

From
D123456

To
D0123456

Can anyone tell me what is wrong with my update statement above?

Thanks.

Danny