获取DelimitedSplit8K的副本，然后可以执行以下操作：
DECLARE @string1 VARCHAr(1000) = ',x,x,y,x,x,O,x,y', @string2 VARCHAr(1000) = '0~1~b~~z~XY~1~7';DECLARE @search VARCHAr(1000) = 'O'; -- best as a variable/parameterSELECt *FROM dbo.delimitedSplit8K(@string2,'~') AS sWHERe s.itemNumber = ( SELECt TOP (1) s2.itemNumber -- TOP (1) until we know about dupicates FROM dbo.delimitedSplit8K(@string1,',') AS s2 WHERe s2.item = @search)-1;
返回值：
ItemNumberItem-------------------- -------6 XY
