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




Reply With Quote