I kind of figured that was what it was doing, or at least hoped, however I could never find any docs on what it was really doing.

But since I could never get a perf increase or decrease I could only assume, and this thread seemed like the perfect place and oportunity to ask that question.

I would imagine depending on the database there is an option to override the behavior but I have never ran into that as well. A lot of programming languages are set up this way.

For Example in C#

say int he example below Both Method returned true

if(DoMethod1() || DoMethod2())
{}

In that example Method 1 would fire and eveluate to true so method 2 would never fire.

if(DoMethod1() | DoMethod2())
{}

Would actually still force both methods to fire then evaluate to true.

I just never knew if SQL did that or not.