title: Pass multiple parameters in a stored procedure to a QueryString Parameter
body: <p>How can pass two SQL parameters in a stored procedure to a query string in the WHERE clause? The issue I'm having is in the @iField. If I remove that and replace with InfoID LIKE '%' + @iSearch + '%', it works, but I need to add the @iField.<br /><br /><code>WHERE CustomerID = @CustomerID AND @iField LIKE '%' + @iSearch + '%'</code></p>