> Also note that the "not exists" statement takes much longer to > return the selection than the "is null" statement which is almost instant.
This could be symptomatic of a bad index (if "not exists" does not use indexes and "is null" does). -- Larry
