combine "in" and "like"

[BHScripter]

Hi:

I'm trying to narrow down my search criteria for a set of completed learning activities by two possible words in a course name.

I tried to do the following in the where clause and it didn't work:

where a.activity in like('%Sales%', '%Service%')

I can't use an "or" as there are other conditions which are included in the where clause that must be met. Is there a way to use like in an "in" statement?

Thanks for any help

 

[SkipVought]

hi,

I can't use an "or" as there are other conditions

Why not

Where....
  AND (a.activity like '%Sales%' OR a.activity like '%Service%')

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[markros]

No, there is no ability to use IN and like.

You can use parenthesis, though, e.g.

where (a.Activity like '%Sales%' or a.Activity like '%Service%') and A.SomeOtherField = 5

 

[BHScripter]

DUH! Thanks so much it should have reached out and smacked me.