求sql
CP表
AcceptAttach字段(varchar)
application/x-pmd|*/*
application/x-smaf
image/gif
image/jpeg|*/*
image/png|*/*
说明:
AcceptAttach字段记录的值有可能包含'|',如果包含'|',取出'|'前的内容,否则取出整个字段。例如:application/x-pmd|*/* 则 取出application/x-pmd。然后取出满足条件application/x-pmd在@Header中存在的记录。
declare @Header varchar(200)
set @header='fdsfsd,application/x-pmd,fdsfs'
sql:
select * from CP
where
CHARINDEX
(SUBSTRING(AcceptAttach,0,CHARINDEX('|',AcceptAttach)),@Header)<>0
我想当CHARINDEX('|',AcceptAttach)=0时 返回 Len(AcceptAttach),怎么用case