>>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 ('bdce',' ','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 >>>
INDEX ON IIF(empty(Field2), Field1,Field2) + Field1 + IIF(empty(field2), Field3, DTOS(Field3)) TAG myComplexTagnot tested, of course, just from the top of my head.