Update Query

[Ken Hutson]

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]

Try ....

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

RD

 

[Ken Hutson]

Thank you RDH!

Ken Hutson
San Antonio, Texas

Try ....

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

RDH