Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is better and faster
Message
From
19/01/2005 07:35:06
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00977833
Message ID:
00978481
Views:
48
Yes, but to find it was a real PITA. Nothing under Select - SQL, who tries all the different See also links? I tried to search for SELECT LIKE and got 101 hits, SELECT SQL LIKE gave me 29 hits, but I did find it myself at last. The logical place would be just before LIKE() in the index, but nothing there. So I thought 'what the heck', the syntax for LIKE and LIKE() are probably very similar. :-)

By the way, I did submit a comment to the VFP team.

>>Hi Sergey,
>>
>>you are absolutely right, of course. The documentation for the LIKE operator is terrible, you really have to dig hard to find it. I have no experience with SQL server, so I tried the syntax which seemed most likely to me, LIKE 'X*' in stead of LIKE 'X%'.
>
>In VFP9 help it's covered quite nicely under Filter Conditions for Queries and Views.
Previous
Reply
Map
View

Click here to load this message in the networking platform