I don't believe it will execute the OR if the first expression is true. But
you can test it easy enough by making the UDF error if called and run it.
Andrew J. Kelly
SQL Server MVP
"Zig Mandel" <nonehotmail.com> wrote in message
> I have a trigger that looks like this (simplified):
> [assume a table T with a bit column 'fSelected']
> trigger for table T:
> CHECK(fSelected=0 OR UserFunction1())
> in most cases, fSelected will be 0. Does that mean that the
> call will not be executed by the server? (this ...