getting wrong results with multiple like statement

[sap1958]

select JobscoID,jobstitle,jobsdiv
from Jobs
where Jobstatus in ('active','retired')
group by JobscoID,jobstitle,jobsdiv
having JobscoID = 0119
and jobstitle like '%Chair%'
or jobstitle like '%Director%'

I am ok with the fist like statement. When I insert the second like statement I get records that do not belong to JobscoID 0119. What I would really like to do is put the like statement in an array like this like ('%Chair%','%Director%'). Sql 2005 does not allow me to do this. Any ideas

 

[bborissov]

Sure you will get the wrong result.
When you have mixed AND and OR clauses use brackets to handle the logic.

select JobscoID,
       jobstitle,
       jobsdiv
from Jobs
where Jobstatus in ('active','retired')
group by JobscoID,jobstitle,jobsdiv
having JobscoID = 0119
   and (jobstitle like '%Chair%'
    or jobstitle like '%Director%')

BTW you do not need GROUP and HAVING here.

SELECT DISTINCT JobscoID,
       jobstitle,
       jobsdiv
FROM Jobs
WHERE Jobstatus in ('active','retired')
  AND JobscoID = 0119
  AND (jobstitle like '%Chair%'
   OR jobstitle like '%Director%')

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.