Hi All,

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

Aloha,

James