>Does MSSQL have VFP's equivalent to pViews or do I use Prepared SQL Statements with parameter markers or should I just execute dynamic-SQL?

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