Filtering database data

Question

Hello,
I am working on a project where I have check box list and a datagridview. I populate datagridview from database. Now, what I need is to populate datagridview from database depending on checked items in check box list.
I am working in VS 2010, sqlCEserver, .net 3.5
I was wondering is there a way to do this:

SELECT * FROM articles WHERE name LIKE <items checked in checkboxlist>?

I think this will solve my problem.
Please help.