Yes, I resorted to using SPs. VFP's views (local and remote) are so flexible to use so I though maybe MSSQL might have similar fuctionality but SPs are good enough for me.

Thanks Bob.

>The closest equivelent would be a stored procedure...
>
>CREATE STORED PROCEDURE
>
>(@startdate datetime
>,@enddate datetime
>)
>
>AS
>
>SELECT * from MyTable where invoicedate is between @startdate and @enddate
>
>RETURN
>*******
>Then you can call this will SPT in VFP and it will return a result set.
>
>BOb