I do not get any results with my stored procedure

[prfalco]

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_selecciono_nombres(@nomb varchar(15)) as
select first_name_vc,last_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:

Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim last_name As String

Private Sub Form_Load()

last_name = "what ever"

conn.Open "driver=sql server;server=informat01;database=wrox"

If conn.State = adStateOpen Then

'call stored procedure with one parameter
rs.Open "pablo.sp_selpar_selecciono_nombres('" & last_name & "')", conn, adOpenStatic, adLockReadOnly, adCmdStoredProc

'load the grid with the recordset...
Set grid.DataSource = rs

End If

End Sub

And I see no records in the grid.....
Can I have some help with this? Thank you in advance.