Hi all,
Is it possible to write a select statement that can take a quantity and add that many records to the result?
What I am trying to achieve is to start with a file containing:

Qty   Desc
 3    Hello
 2    Goodbye

And get a resulting table of:

Hello
Hello
Hello
Goodbye
Goodbye

is this possible or must I just use the old Scan and Insert method?

Thanks in anticipation.
Caroline