Jim:

I just experiemented with the Table that the field Number is being pulled from. I changed the field type from Integer to Numeric(4,0) and it works like a charm now.

Question: Why did the Select statement react differently when the filed type for field Number was an Integer - further - was not even consistent in reprducing the same all the time.