Hi Caroline,

You can do that w/o SCAN

SELECT MAX(qty) as MaxQty ;
	FROM mytable ;
	INTO ARRAY laMaxQty
CREATE CURSOR crsTemp ( Qty I)
FOR i=1 TO laMaxQty[1]
	INSERT INTO crsTemp VALUES (i)
ENDFOR

SELECT mt.Desc ;
	FROM mytable mt ;
		JOIN crsTemp ct ON ct.Qty <= mt.qty ;
	INTO CURSOR crsResult

>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