Can I combine two SQL phrase in a single where clause. Here is an example. it hasn't worked for me and I couldn't find any in the help file. I may have more then two publicationID that I'm trying to pull, but I don't know the full name.
I want to able to use "like" and "in" in the same statement.
select PublicationID,publicationname from dbo.tblPublication where publicationname in (like '%Asia Pac%',like '%Global Watch%')
SELECT publicationname FROM dbo.tblPublication where publicationname like '%Asia Pac%',like '%Global Watch%')