例如:字段Assignee的内容是:
Assignee
AO1%A02%A03
SELECT
COUNT(SID) AS 专利数量
FROM
(
SELECT
DISTINCT SID
FROM
WF_132_WKK_TEST,
MASTER..SPT_VALUES
WHERE
TYPE='P'
AND SUBSTRING('%'+Assignee,NUMBER,1)='%'
AND SUBSTRING(Assignee,NUMBER,CHARINDEX('%',Assignee+'%',NUMBER)-NUMBER) IN ('LG电子株式会社','ZTE维创通讯公司')
)t