Thanks Jason. I think over time applying the date criteria first would be most efficient, but wouldn't having to apply string functions over the entire table be costly? I'm going to have to learn more about execution plans. I don't understand what I'm seeing so far.