> >create cursor toindex (field1 c(20), field2 c(20), FIELD3 c(20)) >insert into toindex (field1,field2,FIELD3) values ('abcd', ' ', 'number1') >insert into toindex(field1,field2,FIELD3) values('efgh','abcd','31/03/2008') >insert into toindex(field1,field2,FIELD3) values('ghij','bcde','11/05/2008') >insert into toindex(field1,field2,FIELD3) values('hiij','bcde','18/05/2008') >insert into toindex (field1,field2,FIELD3) values ('bcde',' ','number2') >insert into toindex(field1,field2,FIELD3) values('fghi','abcd','01/03/2008') > >what I need is a sequence : > >abcd " " number1 >efgh abcd 31/03/2008 >fghi abcd 01/03/2008 >bcde " " number2 >hiij bcde 18/05/2008 >ghij bcde 11/05/2008>field number 3 contents either characters in which case field number2 = empty or a date(dd/mm/yyyy)