CHARINDEX

实现查询条件多个值的或的关系

Select Id,Name from CustTable
where  CharIndex( CustTable.Name, 'ACDE,BEX,CCC')>0
CustTable.Name = 'ACDE' Or  CustTable.Name = 'BEX' Or CustTable.Name = 'CCC'

 

posted @ 2016-10-31 14:07  szlailai  阅读(188)  评论(0)  编辑  收藏  举报