sql语句：

select case ISNULL(case ISNULL(CA.ip) when true then C.crsIp else CA.ip  end) when true then '该设备已被删除' else (case ISNULL(CA.ip) when true then C.crsIp else CA.ip  end) end as ip,case ISNULL(case ISNULL(CA.cameraName) when true then C.crsName else CA.cameraName end) when true then '该设备已被删除' else (case ISNULL(CA.cameraName) when true then C.crsName else CA.cameraName end) end as devname,F.faultCode,F.memo,F.isLock,F.startTime,F.endTime from fault_list as F left join crossing as C on F.faultCode=C.crsCode left join camera as CA on F.faultCode=CA.cameraCode where F.isLock=1

现在我想用devname或ip进行模糊查询 该怎么写 说明一下 我在sql字段中用了条件语句