select case
WHEN CHARINDEX('1425,',inquiry.Q441)>0 and CHARINDEX('1426,',inquiry.Q441)=0 THEN '01'
WHEN CHARINDEX('1426,',inquiry.Q441)>0 and CHARINDEX('1425,',inquiry.Q441)=0 THEN '02'
WHEN CHARINDEX('1425,',inquiry.Q441)>0 and CHARINDEX('1426,',inquiry.Q441)>0 THEN '01'
END
from test t
注意如果找不到应该是=0,而不是<0
常用代码如下:
'Q5.“请问您觉得我们公司提供的理赔服务还有什么意见或建议吗?”'=
case
WHEN inquiry.Q330 like'938%' THEN REPLACE(inquiry.Q330,'938㊣','')
WHEN inquiry.Q330='939' THEN '是'
END,