mmmm...that gives me no results.... the % would have to be somewhere else but I know what ya mean...

>Add % to get LIKE return the same result

Select * From Table1 Where Field1 like 'Myvalue %'

>
>>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?