create proc prcselectfirm
@Client varchar(40)
as
set @Client='%'+@Client+'%'
select * from from where vClient like @Client
@Client varchar(40)
as
set @Client='%'+@Client+'%'
select * from from where vClient like @Client
as
begin
exec ('select * from firm where vClient like ' + @Client +'''')
end