Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is LIKE universal?
Message
De
20/02/2008 16:57:35
 
 
À
20/02/2008 16:19:38
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 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01294481
Message ID:
01294494
Vues:
23
>The following is compliant with VFP and SQL Server:
>
>
>SELECT * FROM MyTable WHERE MyCharacterField LIKE "P%"
>
>
>where the double quote has to be changed for a single quote in SQL Server. The inclusion of the text string in here is only as representative as in my environment, it is of course passed as a parameter. But, my question is mostly about the LIKE syntax. Is this universal? Is the LIKE syntax recognized in Oracle, for example?

It is in single-quote in Oracle as well. I believe it is defined in the SQL92 standard which VFP does not subscribe to.

Regards,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team

Oracle - When you care enough to use the very best!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform