问：如何在SBO报表设计器中对LastName+FirstName进行条件查询?
答：
declare @strUsr varchar(100)
select @strUsr=a.FirstName FROM OHEM a WHERE a.LastName like '%[%0]%' or IsNull('[%0]','')=''
select @strUsr='[%0]'
select_ * FROM OHEM T0 WHERE LastName+FirstName like '%' + @strUsr + '%'
select @strUsr=a.FirstName FROM OHEM a WHERE a.LastName like '%[%0]%' or IsNull('[%0]','')=''
select @strUsr='[%0]'
select_ * FROM OHEM T0 WHERE LastName+FirstName like '%' + @strUsr + '%'
本文转自foresun 51CTO博客，原文链接：http://blog.51cto.com/foresun/146952，如需转载请自行联系原作者
