SQL同一条件多字段查询 - MS-SQL Server / 疑难问题

有一个表，如下：
create table #tmp(id int,cusno varchar(10),cusname nvarchar(50))

insert into #tmp(id,cusno,cusname)
select 1, 'C10001', '联想电脑' union all
select 2, 'C10002', '惠普电脑' union all
select 3, 'C10003', '谷歌公司'

drop table #tmp

如何实现，可根据cusno查询得到cusname结果，或者根据cusname查询得到cusname结果：
select cusname from #tmp where cusno like '%C%'
select cusname from #tmp where cusname like '%电脑%'

create procedure sp_test
@str nvarchar(20)
as
--select cusname from #tmp where cusno like '%+@str+%'

存储过程如何实现，多谢！

---

SQL code:
select cusname from #tmp where cusno like '%C% or cusname like '%电脑%'

---

SQL code:
select cusname from #tmp where cusno like '%C%' or cusname like '%电脑%'

---

SQL code:

create procedure sp_test
@str nvarchar(20)
as

select cusname from #tmp where cusno like '%'+@str+'%' or cusname like '%'+@str+'%'

---

create procedure sp_test
@str nvarchar(20)
as
begin
  select cusname from #tmp where charindex(@str,cusno) > 0