General information
Category:
Coding, syntax & commands
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only