？如何检索字符串书面上的一部分，在SQLServer中的分隔符

如果你的表1有一个标识字段（我已经把它命名为标识），这里是另一种解决方案:codeprelang="SQL"spanclass="code-keyword"select/spanTable1.Id,Table1.AreaCodespanclass="code-keyword"from/span(spanclass="code-keyword"select/spanId,areaidspanclass="code-keyword"from/span(spanclass="code-keyword"SELECT/spanid,CAST(spanclass="code-string"'/spanspanclass="code-string"<r'/span+REPLACE(AreaCode,spanclass="code-string"'/spanspanclass="code-string",'/span,spanclass="code-string"'/spanspanclass="code-string"</r<r'/span)+spanclass="code-string"'/spanspanclass="code-string"</r'/spanspanclass="code-keyword"AS/spanXML)AreaCodeXmlspanclass="code-keyword"FROM/spanTable1)NewAreaspanclass="code-keyword"CROSS/spanAPPLY(spanclass="code-keyword"SELECT/spanAreaId.value(spanclass="code-string"'/spanspanclass="code-string".'/span,spanclass="code-string"'/spanspanclass="code-string"int'/span)AreaIdspanclass="code-keyword"FROM/spanNewArea.AreaCodeXml.nodes(spanclass="code-string"'/spanspanclass="code-string"r'/span)spanclass="code-keyword"AS/spanAreaCodes(AreaId))Splitedspanclass="code-keyword"where/spanAreaId=spanclass="code-digit"2/span)res1spanclass="code-keyword"inner/spanspanclass="code-keyword"join/spanTable1spanclass="code-keyword"on/spanres1.id=Table1.id/pre/code请更换一个变量或参数2...希望它能帮助RaisKazi
。尝试如下查询

Select * from Table1

Where AreaCode LIKE '%,' + @Parameter + ',%' -- In middle

OR AreaCode LIKE @Parameter + ',%' -- In beginning

OR AreaCode LIKE '%,' + @Parameter -- At the end



OR AreaCode =  @Parameter -- Only Sngle value

thatraja:您需要使用通配符搜索的东西，是指这些imgsrc={A}]