Glad it helped.
By the way, for small tables and for critical applications you may use this to check for corrupted indexes. Let us say you have index on the character field name 'testcdx'. Then set filter to testcdx="" and select * from ... where testcdx="" should give different results if index is corrupted.


>I reindexed the table....that fixed the problem...thanks!
>
>>If it is "like", then you should see the difference, but if it is "=" , then results should be the same. In case you use "=" in both, do the results differ substantially, or it is one-two records? If there are a few records it may indicate that index file is corrupted.
>>
>>>This has to be a stupid question...but for the life of me I just don't get it.
>>>Anyone know why #1 would be giving me records that dont show up in #2 ???
>>>
>>>1.
>>>Select Table1
>>>Set Filter to Field1 = 'Myvalue '
>>>
>>>2.
>>>Select * From Table1 Where Field1 like 'Myvalue '
>>>
>>>I've tried using an '=' instead of the 'like'...still end up with same results...
>>>I made these examples look like what Im doing here (the spaces at the end and all)
>>>Made sure the records were not deleted or something lame like that...
>>>....driving me nuts..anyone gotta clue?