• I didn't think of them but now that you pointed them out, you are right on both observations.

    1. A single table starting at zero and a pass-through view with a >0 critiera.

    2. Number1 and Number0 would be easier for casual user.

    >if the use of BETWEEN is a pain

    I'm curious how you would use BETWEEN when you need a zero-based number table.