Solved

Multiple Like

Posted on 2013-06-13
1
320 Views
Last Modified: 2013-06-13
Hello All,
How to make the foolowing into a multiple like condition:
select DrugLabelName,* from Reorders where DrugLabelName like '%skittles'
union
select DrugLabelName,* from Reorders where DrugLabelName like '%FAX MACHINE%'

Open in new window


Thanks.
0
Comment
Question by:Star79
1 Comment
 
LVL 33

Accepted Solution

by:
paulmacd earned 500 total points
ID: 39245504
SELECT DrugLabelName,* FROM Reorders WHERE (DrugLabelName LIKE '%skittles') OR (DrugLabelName LIKE '%FAX MACHINE%')
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now