问从表的多个列中搜索特定值

EN

select t.*, q.*
from t cross apply
     (select qual, col
      from (values (P1_QUALITY, 'P1_QUALITY'), (P2_QUALITY, 'P2_QUALITY'), (P3_QUALITY, 'P3_QUALITY')
           ) v(qual, col)
      where qual <> 'C'
     ) q;

SELECT CASE 
WHEN P2_QUALITY <> 'C' and P3_QUALITY <> 'C' THEN 'P1_QUALITY'
WHEN P1_QUALITY <> 'C' and P3_QUALITY <> 'C' THEN 'P2_QUALITY'
WHEN P1_QUALITY <> 'C' and P2_QUALITY <> 'C' THEN 'P3_QUALITY'
END AS 'Result'
FROM TABLE_NAME

SELECT t.*,
(CASE 
 WHEN P1_QUALITY NOT LIKE 'C%' THEN 'P1_QUALITY'
 WHEN P2_QUALITY NOT LIKE 'C%' THEN 'P2_QUALITY'
 WHEN P3_QUALITY NOT LIKE 'C%' THEN 'P3_QUALITY'
 END) AS [NotC]
FROM YourTable t;

WHERE CONCAT(P1_QUALITY, P2_QUALITY, P3_QUALITY) NOT LIKE 'C%C%C%'