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