like 问题 解决立马结帖

[happy664618843]

tbInstanceInfo表数据如下 值为:
DBName                                       InstanceName
ReportServer_HFM                     MSSQLSERVER;ReportServer_HFM
ReportServer_HFMTempDB      MSSQLSERVER;ReportServer_HFMTempDB 
HFM                                                MSSQLSERVER:HFM

当我select * from tbInstanceInfowhere InstanceName like '%ReportServer_HFM%'
会查询出来两条数据。

我想根据ReportServer_HFM关键字查询只查询出来一条数据。

[shoppo0505]

select * from tbInstanceInfo where ';' + InstanceName + ';' like '%;ReportServer_HFM;%'

[happy664618843]

引用 1 楼 shoppo0505 的回复:

select * from tbInstanceInfo where ';' + InstanceName + ';' like '%;ReportServer_HFM;%'

3q 我试下！

[学海无涯-回头是岸]

直接 select * from tbInstanceInfo where InstanceName like '%ReportServer_HFM' 或者 select * from tbInstanceInfo where InstanceName = 'ReportServer_HFM'

[中国风]

或用 e.g.

select * from  tbInstanceInfo where CHARINDEX(';ReportServer_HFM;',';' + InstanceName + ';')>0

select * from  tbInstanceInfo where PATINDEX('%;ReportServer_HFM;%',';' + InstanceName + ';' )>0

[LongRui888]

如果分隔符都是 分号 ，可以用这个： select * from tbInstanceInfowhere ';'+InstanceName+';' like '%;ReportServer_HFM;%'

[shadowpj]

select * from tbInstanceInfo where InstanceName like '%ReportServer_HFM'