Viewing 2 posts - 1 through 2 (of 2 total)
No Doubt, Gentleman its an good question. Another alternate answer for this is
UPDATE table1 SET col1 = case col1 when '1' then '0' else '1' end
Regards,
Vineet Yadav
Sr....
October 27, 2011 at 8:18 am
#1400175
The 2nd Select Stmt will return the value 1, Then how the value 2 is the answer for this question??
Please be sure while locking your answer.
October 21, 2011 at 5:35 am
#1397872