>let me make myself more clear
>
>eg i have a local table and would like to fetch the results from another table on the sql server using one of the fields as the parameter.
>
>suhas

Suhas,
OpenRowset() - You already have the details, for others to benefit I'm writing the sample here too :)

Create Table myCountries (country c(10))
Insert into myCountries values ('USA')
Insert into myCountries values ('Germany')
Insert into myCountries values ('Canada')
use

lnHandle=SQLStringConnect('DRIVER=SQL Server;SERVER=servername;Trusted_connection=Yes')
SQLExec(lnHandle, ;
 "select * from Northwind.dbo.customers as rmtR"+;
 "   inner join OPENROWSET('VFPOLEDB.1', "+;
 "   '"+Sys(5)+Curdir()+"';'';'',"+;
 "   'select * from myCountries') as locR"+;
 "  on rmtR.country = locR.country",'myResult' )
SQLDisconnect(lnHandle)

Cetin