> It's important to determine how the end points function. If the starting point of the "user described range" is considered to overlap the ending point of a record, then BETWEEN will work for you. An application similar to this did not consider this to be an overlap. In that situation, Garrett's approach will work for you.

10-4. It's not considered an overlap, so the IF ... OR ... should do the trick.

Thanks for the input.