select btypeid,
from btype
where bsonnum=0 and (bfullname +'^^^' + busercode +'^^^' + bnamepy +'^^^' person like '%1%')
order by b.btypeid 里面的where后面的条件的这种格式从来没有见过,在帮助文档里面没有找见。麻烦高手指点解释一下。谢谢!~
from btype
where bsonnum=0 and (bfullname +'^^^' + busercode +'^^^' + bnamepy +'^^^' person like '%1%')
order by b.btypeid 里面的where后面的条件的这种格式从来没有见过,在帮助文档里面没有找见。麻烦高手指点解释一下。谢谢!~
declare @btype table (btypeid int,bsonnum int,bfullname varchar(32),busercode varchar(32),bnamepy varchar(32),person varchar(32))
insert into @btype select 1,0,'sd','er','ert1','asg214'
union all
select 2,0,'sd','efsr','ert','asg'
union all
select 3,0,'sd','efsr1','ert','1asg'select btypeid,(bfullname +'^^^' + busercode +'^^^' + bnamepy +'^^^' +person) as result
from @btype
where bsonnum=0 and (bfullname +'^^^' + busercode +'^^^' + bnamepy +'^^^' +person) like '%1%'
order by btypeid /*
btypeid result
1 sd^^^er^^^ert1^^^asg214
3 sd^^^efsr1^^^ert^^^1asg
*/