I don't know if I should answer yes or no to these questions or if they are even asking the same thing or the oposite think (if I googled opportunistic I got a lot of hits about infection lol)

Anywho. If the first condition is met the second is not checked.

Proof:
SELECT * FROM myTable WHERE 1 = 1 OR Id = 5
gives the same result as
SELECT * FROM myTable

q.e.d.

Einar

>Is the OR statement opportunistic in SQL Server 2000?
>
>IOW, if the first condition is met, does it check the second?
>
>TIA,
>
>-Justin