> Why is his approach wrong, Sean? It might be unusual to have the constant
> on the left side of a comparison, but I'm sure I've done it when it is the
> easiest way to write a query.

Agreed, that might be my own bias showing. Also, BETWEEN would not use indexes whereas my query would ;-]


Sean