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?