multiple updates in one statement
I have the following data in a table -
Code field1 field2
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.