>Never say never. :)
>
>See Cetin's today post Re: How to use SQL OpenRowSet thru VFP9 Message #1170966
>
>>You can't. You must prepare the list and SELECT beforehand.
>>

>>SELECT .... && your "I want to use here vfp Statement"
>>lcList = []
>>SCAN
>>   lcList = lcList + IIF(EMPTY(lcList),[],[,]) + TRANSFORM(FieldName)
>>ENDSCAN
>>
>>SQLExec(gnconnhandle,'select * from product where  prcode in ('+ lcList+ ')','product')
>>
>>

I read it. But I doubt (I can't test it right now) that if the DBF is on my local machine (no shares) and SQL Server is somewhere in space the OPENROWSET will works.
Also isn't my way faster than with OPENROWSET() :-)
But you are right, always there is a way. If I remember right one Russian saying says: Если нельзя, но очень хочится - то можна :-). Excuse me for the spelling, I didn't wrote in Russian almost 20 years.