returning a constant set of numbers from a "select"

From: p! <p!_at_unix.ndo.co.uk>
Date: Mon, 21 Jul 2003 13:10:40 GMT
Message-ID: <3f1be5ed.15540453@news>

hi,

could anyone tell me how i can do the following:

would like a select statement which returns all the numbers between a variable start and end point as seperate rows without using a "proper" table, ie:

result

---

1
2
3
4
5
6
7
8
9
10
..
1000

any ideas?!

thanks,
p! Received on Mon Jul 21 2003 - 08:10:40 CDT