>>>Hi Gregory,
>>>
>>>thanks, I search for something without FOR and SCAN. (Didn't I mention this in the initial message?).
>>>
>>>Agnes
>>
>>
>>But Agnes, this is without scan/for - you just need to set up a temp table once
>>To me it is an SQL select
>
>{snip}

>	create cursor Chair ;
>	( ;
>		Id	I ;
>	)
>	local i
>	for i = 1 to 8
>		insert into Chair values (m.i)
>	
>	endfor
>

{snap}
>
>looks like a FOR loop to me ...
>
>(^.^)
>Agnes

George Mastros (SQL Server expert) has Numbers table in each of his databases.