CREATE PROCEDURE QueryData ( > @ScoreExpression nvarchar(50), > @tcZipExpression nvarchar(50)) >AS >BEGIN > DECLARE @Sql nvarchar(4000) > SET @Sql = 'SELECT * FROM Table ' + > ' WHERE Score ' + @tcExpression + > ' AND ZIP ' + @tcZipExpression > EXECUTE (@Sql) > >END >You can as well build that query string in VFP and send to SQL Server for excution w/o creating stored procedure.
>>ScoreExpression=[BETWEEN '950' AND '1135'] >>ZipExpression=[LIKE '967%'] >> >>CREATE PROCEDURE (QueryData @ScoreExpression NVARCHAR(50), @tcZipExpression NVARCHAR(50)) >>AS >>BEGIN >> Select * From Table WHERE >> Score @tcExpression AND >> Zip @tcZipExpression >>END >>GO >>