sql里面的^是什么意思啊上面的语句看不懂_Sql Server

sql里面的^^^是什么意思啊，下面的语句看不懂
select btypeid,
from btype
where bsonnum=0 and (bfullname +'^^^' + busercode +'^^^' + bnamepy +'^^^' person like '%1%')
order by b.btypeid

里面的where后面的条件的这种格式从来没有见过，在帮助文档里面没有找见。麻烦高手指点解释一下。谢谢！~

------解决方案--------------------
够变态的。应该是把那几个字段内容联合起来，然后从这个内容里查数据
------解决方案--------------------

探讨
select btypeid,
from btype
where bsonnum=0 and (bfullname +'^^^' + busercode +'^^^' + bnamepy +'^^^' person like '%1%')
order by b.btypeid

里面的where后面的条件的这种格式从来没有见过，在帮助文档里面没有找见。麻烦高手指点解释一下。谢谢……

------解决方案--------------------

SQL code

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*/