>Gregory,
>
>if I change to
>

>	create cursor Schnaps ;
>	(	c1	c(1), ;
>		c2	c(1),; 
>		c3	c(1),;
>		iOrder	I ;
>	)
>	
>	insert into Schnaps values ('A', 'a', '1',1)
>	insert into Schnaps values ('A', 'b', '2',2)
>	insert into Schnaps values ('A', 'b', '3',3)
>	insert into Schnaps values ('A', 'b', '3',4)
>	insert into Schnaps values ('B', 'c', '4',5)
>	insert into Schnaps values ('B', 'd', '4',6)
>

>
>just to have an order (the import has some relevance in its order, but SQL wil not work with recordnumbers)
>
>What I need now is to delete any record with multiple definitions of c3 except the first one.
>
>Result should be:
>

>('A', 'a', '1',1)
>('A', 'b', '2',2)
>('A', 'b', '3',3)
>('B', 'c', '4',5)
>

>
>Agnes

SELECT c1, MIN(c2) as c2, c3, MIN(iOrder) as iOrder FROM schnaps GROUP BY 1,3

Cetin