Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set Filter To returns different results than Select ???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00795392
Message ID:
00795398
Vues:
20
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?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform