how can i use % in an "in" statement SQL

Question

I'm trying to say if the event has '%webinar%','%network%' in the name include it "if" the date is after the 01-04-2015. I cant use "or" on a separate line as it ignores the date. Any help appreciated.

select 
    ,fsa.eventid
    ,sev.EventStart
    from
    event sev
    on 
    sev.eventId = fsa.eventid
    where sev.SNAP_EventStart >= '2015-04-01'
    and eventidname in ('%webinar%','%network%')

you can use `or` if you place the paranthesis correctly... (operator precedence, `and` before `or`) — SomeJavaGuy, Apr 20 '16 at 08:34
`..and (eventidname LIKE '%webinar%' OR eventidname LIKE '%network%')` — Mihai, Apr 20 '16 at 08:36
Possible duplicate of [Combining "LIKE" and "IN" for SQL Server](http://stackoverflow.com/questions/1865353/combining-like-and-in-for-sql-server) — GSerg, Apr 20 '16 at 08:39

score 2 · Answer 1 · answered Apr 20 '16 at 08:37

2

please try

... where sev.SNAP_EventStart >= '2015-04-01'
    and (eventidname like '%webinar%' or eventidname like '%network%')

answered Apr 20 '16 at 08:37

Pirvu Georgian

657
1
12
37

score 0 · Answer 2 · answered Apr 20 '16 at 08:41

0

Try this way

SELECT  * 
FROM    table t INNER JOIN
        (
            SELECT  '%webinar%' Col
            UNION SELECT '%network%' col
        ) a ON t.COLUMN LIKE a.Col

answered Apr 20 '16 at 08:41

Mukesh Kalgude

4,814
2
17
32

score -1 · Answer 3 · answered Apr 20 '16 at 11:01

Try this.

select ,fsa.eventid ,sev.EventStart from event sev on sev.eventId = fsa.eventid where sev.SNAP_EventStart >= '2015-04-01' and ( Patindex('%webinar%', eventidname) = 1 OR Patindex('%network%', eventidname) = 1 )

how can i use % in an "in" statement SQL

3 Answers3