Techinical Term..

[Goksly]

Whats the techy term for a situation where...

In an ORstatement it will stop checking when it hits something thats true, where as in an AND it will stop checking the conditions when it hits something that is false?

It's obviously some optimisation stuff (i.e. put the stuff you think it most likely to fail first)... but can't for the life of me remember! I know C# does this, but guy at work said SQL doesnt - but I think it does!

Cheers

 

[voodooflux]

Short-circuit evaluation

 

[Ladforce]

An OR statement will tell you if one or both of a pair of evaluations are true and an AND will tell you if a pair of evaluations are both true. Is this what your asking for?

 

[Goksly]

Nar, voodoo has got it. Basically, if one part of an 'AND' statement fails, its pointless to check the remaining conditions - cos whether they true or false, the over all statement has failed.
Cheers

 

[Ladforce]

Ah gotcha