with test as (select 'HCG 陶瓷1414白光系列;专利:无;喷码示意图:CS-1Y1-03A;固晶示意图:DB-1Y1-0101-05D;贴膜示意图:TM-1Y1-03B;标准件:HCG-D1414H-002-0101C4080SC;CF3代码:CF3-HCG-0033;CF2代码:CF2-HCG-0033;SPEC分光代码:SPEC-HCG-SC-0033' [a])select (CASE WHEN CHARINDEX('CF3代码',A)>0 THEN SUBSTRING(A,CHARINDEX('CF3代码',A)+6,CHARINDEX(';',SUBSTRING(A,CHARINDEX('CF3代码',A)+6,LEN(A)))-1) ELSE '无' END) [CF3] from test