>Hi,
>
>
>Those brackets! of course you are correct. Please note it is 23:39 in Amsterdam. Anyhow your solution:
>
>INDEX ON IIF(empty(Field2), Field1,Field2) + IIF(EMPTY(field2),FIELD2,DTOS(CTOD(field3))) TAG mytag
>results in:
>abcd " " number1
>efgh abcd 31/03/2008
>fghi abcd 01/03/2008
>hiij bcde 18/05/2008
>ghij bcde 11/05/2008
>bcde " " number2
>
>so need a little bit fineturnig 2morrow 1stthing!
>
>Thanks sofar,
>Bye,
>Koen
Check my other reply. I added 1/2 for empty field and PADR just in case.
If it's not broken, fix it until it is.
My Blog