asked on Select SQL Query Multiple phrases using "like" parameter
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,publicationn
I want to able to use "like" and "in" in the same statement.
select PublicationID,publicationn
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
Last Comment
vb7guy
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
oops dont care about mine, i accidently press the subit button :)
ASKER
Aaah, Thanks. "OR" is what I thought. But I wish if it was easy to just use "IN" statement and "LIke" phrase. Thanks
SELECT publicationname FROM dbo.tblPublication where publicationname like '%Asia Pac%',like '%Global Watch%')