Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is LIKE universal?
Message
From
20/02/2008 16:19:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Is LIKE universal?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01294481
Message ID:
01294481
Views:
75
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?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform