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 :Code:Col1 Col2
1 1
1 2
2 2
3 3
Code:Update Table1
Set Col1=A
Where Col2 = 2 AND col1=1
Set Col1=B
Where Col2=2 and col1=2
