Hi -

I have the following data in a table -

Code field1 field2
AAA
BBB
BBB
AAA
AAA
CCC

I want to update AAA with A, BBB with B, CCC with C.
I can do this by separate update statements.

But what i'm trying to do is update all the records with a single update statement. Is there a way to do that ?

Thanks for your help.

Can your try the following

UPDATE WROX
SET Field1 = LEFT(CODE,1)

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)