要查询的是多条数据,根据Status来实现查询条件的更换,要求一条sql语句
select ProName,BeginTime,EndTime,[Status] from L_UsePro
条件1
CHARINDEX(LTRIM(值),ReterId)>0
添加2
CHARINDEX(LTRIM(值),ByReterId)>0
------解决方案--------------------
- SQL code
select ProName,BeginTime,EndTime,[Status] from L_UsePro WHERE CASE status WHEN status1 THEN CHARINDEX(LTRIM(值),ReterId) WHEN status2 THEN CHARINDEX(LTRIM(值),ByReterId) END > 0