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.