sql server odbc: It's ugly, but you can do the following:

update myTable set myField = case myField when 0 then 1 when 1 then 0 end

Or you can write your own user-defined function:

create function myNot(@v bit) returns bit
as
begin
declare @r bit

set @r = case @v when 1 then 0 when 0 then 1 end

return @r
end

and use it like so:

update myTable set myField = dbo.myNot(myField)

Brannon

[quoted text, click to view]