How to make sql statement to get value wanted

I have an array chapters that store the values of the chapters entered through a selection made by the user from a listbox. User can select one or more values in that listbox.

How do I pass the values of the array to an sql string?

for example:

select * 

from Chapters

where chapId= value from array

            chapid = Request.QueryString["chapID"];
           
            if (chapid.Contains(","))
            {
                chapters = chapid.Split(',');
            }