使用存储过程示例代码：

declare @No1 varchar(20)---
declare @NO2 varchar(20)---
select @No1=CardID from CardInfo where customerID in (select customerID from userInfo where customerName='李四')  
select @No2=CardID from CardInfo where customerID in (select customerID from userInfo where customerName='张三')
exec proc_transfer @No1,@No2,'2000'

那么用到了SQL的数据库的查询语句来完成  

select  * from Table where  q3 like '%%' and city like '%%'

拿Winform做个小程序测试是OK的，SQL汇编后的源程序