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