With empty() you have only the 2 states as results. That also means the index has low selectivity, which translates in relatively bad performance of the index - sometimes it is worth than having no index at all. A binary index is ONLY the resulting bitmap of rushmore, which means much less data transfer between data store and client CPU, resulting to nearly always shortest time. So IF you need an index / filter for such a state, ALWAYS add binary clause if using a vfp version supporting it.
HTH
thomas
>binary index? why? how can a binary index help him?
>
>>and if you index the condition be sure to define as binary...
>>
>>>Thank you Marcia.
>>>
>>>It was a grid problem. Not set filter.
>>>
>>>Moises
>>>
>>>
>>>>
Something like: Set filter to not empty(myfield).
>>>>
>>>>But it does not work because this is not the correct syntax.>>>>
>>>>It works for me.
>>>>
>>>>
>>>>Use MyTable in 0
>>>>Select MyTable
>>>>Set Filter To Not Empty(MyFierld)
>>>>Go Top
>>>>Browse Normal
>>>>
>>>>
>>>>Happy New Year to you too..