[Originally posted by m.posseth]

scenario :

i have a table with 2 fields one is a bit field (true - false ) the other is a smallint field

i want to know if it is possible to write a trigger that will set the integer field to 0
if the bit operator is set to 0 ( false )

if possible could someone show a small example ?? (or explain )