Update question

Is it possible to use an 'if' in an UPDATE statement. i.e. If I have a column in a table called Departments and it is made up of various values

(like 'AA' and 'VC') and I want to SET these to be 'OAA' and 'VCA' (not always the same change) do I have to run it one by one manually or can I update them using an IF
statement somehow? I have about 50 different Departments to update, of which there are about 95 records for each.

Thanks in advance! Received on Mon Oct 12 1998 - 00:00:00 CDT