22,210
社区成员
发帖
与我相关
我的任务
分享
[KeyHistory]+[KeyOutline]+[ResumeName]+[SkillTechang] like '%深圳%' or
[KeyHistory]+[KeyOutline]+[ResumeName]+[SkillTechang] like '%总监%'
declare @s varchar(2000)
set @s='深圳,总监'
select @s='COL LIKE ''%'+REPLACE(@s,',','%'' or col like ''%')+'%'''
select @s
COL LIKE '%深圳%' or col like '%总监%'
把
( [KeyHistory] like '%深圳%' or [KeyOutline] like '%深圳%' or [ResumeName] like '%深圳%' or [SkillTechang] like '%深圳%' or [SkillSayme] like '%深圳%' OR [KeyHistory] like '%总监%' or [KeyOutline] like '%总监%' or [ResumeName] like '%总监%' or [SkillTechang] like '%总监%' or [SkillSayme] like '%总监%')
改成
charindex('深圳',[KeyHistory]+[KeyOutline]+[ResumeName]+[SkillTechang])>0
or charindex('总监',[KeyHistory]+[KeyOutline]+[ResumeName]+[SkillTechang])>0
试试~