>Hi Jon,
>
>I've tried the OPENROWSET of SQL and it worked!... I tried it in query analyzer but could'nt make it work in vfp.
>
>I've tried using sqlexec but won't work. Please help...
>
>Thanks in advance...

Mike,
Copy your query from Query analyzer,
In VFP do:

m.lhSQL = SQLSTRINGCONNECT(".....") && Connection string to SQL Server
IF m.lhSQL < 0
   AERROR(laError)
   MessageBox("Can not connect to SQL Server. Reason: "+laError[1,2])
   RETURN
ENDIF

TEXT TO m.lcSQLStatement NOSHOW
    *** Here paste the copied query from Query analyzer
ENDTEXT

IF SQLEXEC(m.lhSQL, m.lcSQLStatement) < 0
   AERROR(laError)
   MessageBox("Can not execute SQL Statement. Reason: "+laError[1,2])
ENDIF
SQLDISCONNECT(m.lhSQL)