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

Hi Justin,

This feature is called short circuit and T-SQL supports it.

IF (1 > 0) OR (1/0 > 0)
  PRINT 'Short circuit'

IF (1/0 > 0) OR (1 > 0) 
  PRINT 'Short circuit'

DECLARE @a int, @b int
SELECT @a=1, @b=0

IF (@a > @b) OR (@a/@b > @b) 
  PRINT 'Short circuit'

IF (@a/@b > @b) OR (@a > @b) 
  PRINT 'Error'

Keep in mind that Query Optimizer can rearange the order of expressions.