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
Semper ubi sub ubi.