>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.