James,

You can build query string and run it using EXECUTE command (similar to VFP EXECSCRIPT()).

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.

>
>Is it possible to pass an expression to a SQL Stored Procedure? Something to the effect of this:
>

>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
>