sql case when like

逛網看到一則:

Select COL1,COL2, case
when COL3 like '%（%' THEN substr(COL3, INSTR(COL3, '（' )+1, INSTR(COL3,'）')-INSTR(COL3,'（')-1)
end as COL3 from MY_TABLE


讓我覺得好奇,不曾這樣用過;小試了一下,哈~真好用:
 declare @a varchar(30)
set @a='一二三四五六654321'
select @a,case when @a like '%5%' then '有' else '無' end as chk