Post reply

Simple update to opposite

  • March 23, 2013 at 8:13 pm

    #272481

    Hi

    I am struggling to find out how can I do the following in my SP.

    UPDATE EmployeeData

    SET

    selected = (NOT selected)

    WHERE SeqNo = 116

    I want to switch this value in BIT coloumn to the opposite

    TIA

  • March 23, 2013 at 8:18 pm

    #1600099

    OK, I found it

    selected = selected ^ 1

    Hope this is better method?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply