sp for search

create proc sa_tstname(@p varchar(20))
as
begin
select lastname from geninfo where lastname like @p+'%'
end
exec sa_tstname c