• thormj,

    The problem is that unfortunately that query will be unable to seek indexes as the optimizer will evaluate ALL of the possible conditions (therefore, a scan will be necessary).

    --
    Adam Machanic
    whoisactive