>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!!