>It doesnt work from VFP, but it works fine from the SQL Query Anaylizer..
>

Bob,

What do you mean by "it doesn't work"? Do you get an error back from SQL Server? I assume your SQL connection from VFP is logging in as a user that has rights to read/select the data?

Laterness,
Jon