Update Query

Ken Hutson · Nov 12, 2003

Hi Group,

Is it possible to use an update query to replace a only portion of a field
value? For example:

UPDATE tblname SET left(fieldname,1) = "A" WHERE left(fieldname,1) = "B";

I have tried this and the query won't save.

Thanks,
Ken Hutson
San Antonio, Texas

R. Hicks · Nov 12, 2003

Try ....

UPDATE tblnames SET fieldname = "A" & Mid([fieldname],2)
WHERE Left([fieldname],1)="B";

RD

Ken Hutson · Nov 13, 2003

Thank you RDH!

Ken Hutson
San Antonio, Texas

R. Hicks said:
Try ....

UPDATE tblnames SET fieldname = "A" & Mid([fieldname],2)
WHERE Left([fieldname],1)="B";

RDH