sql里面的^^^是什么意思啊，下面的语句看不懂
select btypeid,
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 resultfrom @btype where bsonnum=0 and (bfullname +'^^^' + busercode +'^^^' + bnamepy +'^^^' +person) like '%1%' order by btypeid /*btypeid result1 sd^^^er^^^ert1^^^asg2143 sd^^^efsr1^^^ert^^^1asg*/
