In both cases, I was under the impression that a JOIN would slightly outperform an INLIST in a WHERE, and the SQL BETWEEN was actually slightly faster than the BETWEEN function. But either way, I saw your post afterwards and overlooked the part about the # of rows being returned.