Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is better and faster
Message
De
19/01/2005 07:35:06
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
00977833
Message ID:
00978481
Vues:
47
Yes, but to find it was a real PITA. Nothing under Select - SQL, who tries all the different See also links? I tried to search for SELECT LIKE and got 101 hits, SELECT SQL LIKE gave me 29 hits, but I did find it myself at last. The logical place would be just before LIKE() in the index, but nothing there. So I thought 'what the heck', the syntax for LIKE and LIKE() are probably very similar. :-)

By the way, I did submit a comment to the VFP team.

>>Hi Sergey,
>>
>>you are absolutely right, of course. The documentation for the LIKE operator is terrible, you really have to dig hard to find it. I have no experience with SQL server, so I tried the syntax which seemed most likely to me, LIKE 'X*' in stead of LIKE 'X%'.
>
>In VFP9 help it's covered quite nicely under Filter Conditions for Queries and Views.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform