Generate series of numbers

[DaveRobichaud]

Hey everybody!

I'm trying to build a small application that will basically generate a
range of numbers for a specified beginning and end point.

However, it also needs to "shorten" the numbers in assuming that if I
wanted a range from 2000 to 2059, the result should be 200, 201, 202,
203, 204, and 205.
Understanding that the results mean 200*, 201*, and so on.

Conversly, if I put in 2000 to 2038, it will give me results like this:

200, 201, 202, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2037, 2038.

Also, the to and from numbers are not limited to 4 digits... they can
be as high 7 or 8 digits long.

I really don't even know where to begin with this.
Any help would be greatly appreciated!
Thanks in advance,
Dave

 

[John Vinson]

Hey everybody!

I'm trying to build a small application that will basically generate a
range of numbers for a specified beginning and end point.
ok...

However, it also needs to "shorten" the numbers in assuming that if I
wanted a range from 2000 to 2059, the result should be 200, 201, 202,
203, 204, and 205.
Understanding that the results mean 200*, 201*, and so on.

No. I don't understand this. 200 is a smaller number than 2000 and it
is not in the range between 2000 and 2059. For that matter, if any
truncation is allowed, then you should also get 2 and 20.

Where will these non-numeric "numbers" be stored? What is the business
requirement?

Conversly, if I put in 2000 to 2038, it will give me results like this:

200, 201, 202, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2037, 2038.

And not 203?

Also, the to and from numbers are not limited to 4 digits... they can
be as high 7 or 8 digits long.

Truncated to... what? 3? 3, 4, 5, and 6? or what?

I really don't even know where to begin with this.

Me neither, since the requirement appears to make no sense!

John W. Vinson[MVP]