SQL Synatax aarrrrrrgggghhhhhh !!!!

[alex_read]

Col1    Col2
   1       1
   1       2
   2       2
   3       3

Here's what I'm basically trying to do, from what I can see, it doesn't look like I can do 2 set statements, and don't really want 2 sql strings in my coding, can anyone tell me a way to achieve the below please :

Update Table1
Set Col1=A
Where Col2 = 2 AND col1=1
Set Col1=B 
Where Col2=2 and col1=2

[honeybee]

Sorry to disappoint you, but I don't think that's possible. You can use two Set statements with a comma between the fields, but they will have a common WHERE clause. So if you are going to update two fields based on two different criteria, you have to use two separate SQL statements.

.