We help IT Professionals succeed at work.

Help with Select statement

gogetsome
gogetsome asked
on
Hello, I have a column like this:

RK PK XX
INS CHI BIO
EDU GEN HSM
HLT SUP GEN
TNI STB PSZ
EDU SCI CSC
PT WO XX

How do I perform a select statement and pull all rows that contain 'EDU'

select * from products where category = '%EDU%'   --does not work

 
Comment
Watch Question

SQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
select * from products where category LIKE '%EDU%'
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Thanks for the grade.  Good luck with your project.  -Jim