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.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons