[RESOLVED] Toggle boolean value in SQL

[OniLink]

Hi,

Is it possible to toggle a boolean from FALSE to TRUE or TRUE to FALSE in a SQL query. Something like this:

UPDATE clients SET boolean_value = toggle...?

Thanks for any help,
~Oni.

[drew010]

UPDATE clients SET boolean_value = !boolean_value WHERE...

[OniLink]

Thats it! Thanks very much.