Multiple Like

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.
Star79Asked:
Who is Participating?
 
Paul MacDonaldConnect With a Mentor Director, Information SystemsCommented:
SELECT DrugLabelName,* FROM Reorders WHERE (DrugLabelName LIKE '%skittles') OR (DrugLabelName LIKE '%FAX MACHINE%')
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.