Is your invoice number field numeric or is it character?

If numeric do this:

INDEX ON dtoc(date,1)+str(Inv. No.) tag mytag

If character do this

INDEX ON dtoc(date,1)+Inv. No. Tag mytag

Benny


> Dear ALL
>
> I have a table in which i store the invoice data as follows :
>
> Inv No. Date
>
> The Invoice no. has two series running parallel like the following example (both for different kind of products) :
>
> 101 2nd April
> 102 2nd April
> 1001 2nd April
> 103 2nd April
> 1002 2nd April
> 1003 3rd April
> 104 4th April
> 105 4th April
> 106 4th April
> 1004 5th April
> ... and so on
>
>
>
> If i index only on date field, sometimes the invoice nos. go up and down. I want to index in such a way that it should index date first and then inv no. .
>
> The invno field is of character type.
>
> Thanks in Advance
>
>
> Sudhir
>
>
>
>
>