Can a stored procedure receive a char or varchar parameter and then use it inside a select statment in where condition. Example
create procedure customers_browse
condition varchar
as
select * from customers where &condition