問:如何在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 + '%'
本文轉自foresun 51CTO部落格,原文連結:http://blog.51cto.com/foresun/146952,如需轉載請自行聯系原作者