Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is LIKE universal?
Message
De
20/02/2008 17:32:41
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
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:
01294511
Vues:
16
This message has been marked as the solution to the initial question of the thread.
>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?

Yes it is part of ANSI SQL92 specification.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform