The Dixie Flatline (3/31/2010)

---

I agree with Michael:

In your example the numbers are varchar datatyped, not numeric. ...

Glenn Dorling (3/31/2010)

---

What I think you're seeing here is something very similar to when checking dates.

When doing a date range, something like '1-Apr-2010" is interpreted as '1-Apr-2010 12:00:00am'. This...

Thanks for the article. I'm actually working on fiscal based periods at the moment, and have opted to have all of the periods defined in a setup-type table.

E.g.

Period #...