Hi All
Why would a record be found if the sort order is descending and not found
if the sort order is ascending?

I have TIB_Grid, TIB_Query and TIB_IncSearch

Ordering Items
...
INVNO=INVNO;INVNO DESC
...


OrderIngLinks
...
INVNO=4
...

Searching Links
...
INVNO=INVNO
...

The InvNo field does contain nulls
If the search only consists of numeric characters the record is found both
ascending and descending
If the search includes alpha the record is found only if the sort is
descending


Thanks
Cao