That's brilliant Thanks Sergey.
Now I've just got to confirm that it's faster with my data!
Caroline
>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