Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is LIKE universal?
Message
From
20/02/2008 16:57:35
 
 
To
20/02/2008 16:19:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01294481
Message ID:
01294494
Views:
22
>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!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform