> The above is not the same format as OP's query:>> Update tableA set col1 = null and col2 in (1,2);
I did include set in the sql. I typed it wrong here.