Hi there:

I am trying to use a stored procedure which selects rows according to a pattern (well, a parameter I am passing to it) something like this:

create procedure sp_selpar_selec ciono_nombres(@ nomb varchar(15)) as
select first_name_vc,l ast_name_vc
from customer_t
where last_name_vc like '%@nomb%'

Note: I use SqlServer 7.0

Then, from vb 6.0 a call it like this:...