C#

Func<Student, List<int>, bool> MatchFromScoresList = (student, itemList)
    => student.Scores.Any(isMatchingEntry => itemList.Contains(isMatchingEntry));

Func<Student, List<string>, bool> MatchFromCommentsList = (student, itemList)
    => (student.Comments != null) && student.Comments.Any(isMatchingEntry
        => itemList.Contains(isMatchingEntry));

var test1 = students.Where(student => MatchFromScoresList(student, new List<int>{60,91}));

// test for null, since not every Item defines a Comments list
var test2 = students.Where(student => MatchFromCommentsList(student, new List<string> { "one", "two"}));

var test1 = Enumerable.Where(students, student
    => MatchFromScoresList(student, new List<int>{60,91}));

Func<Student, dynamic, bool> dynMatchFromScoresList = (student, itemList)
    => student.Scores.Any(isMatchingEntry => itemList.Contains);

Func<Student, dynamic, bool> dynMatchFromCommentsList = (student, itemList)
    => (student.Comments != null) && student.Comments.Any(isMatchingEntry
        => itemList.Contains(isMatchingEntry));

Func<Student, dynamic, bool, bool> dynMatchFromMultiTypeList = (student, itemList, isListType) =>
    (isListType)
    ?
       // integer list 
       (student.Comments != null) && student.Comments.Any(isMatchingEntry
        => itemList.Contains(isMatchingEntry))
    :
       // string list
       (student.Comments != null) && student.Comments.Any(isMatchingEntry
        => itemList.Contains(isMatchingEntry));

// test
var test0 = Enumerable.Where(students, student => dynMatchFromMultiTypeList(student, new List<int> { 88, 91 }, true));

public class Student
{
    public string First { get; set; }
    public string Last { get; set; }
    public int ID { get; set; }
    public List<int> Scores;
    public List<string> Comments;
}

private List<Student> studentList;

// initialization
private void initializeStudentList()
{
    // sample data copied from somewhere on one of MSDN's pages on Linq
    studentList = new List<Student>
    {
        new Student {First="Svetlana", Last="Omelchenko", ID=111, Scores= new List<int> {97, 92, 81, 60}, Comments = new List<string>{"one","two"}},
        new Student {First="Claire", Last="O’Donnell", ID=112, Scores= new List<int> {75, 84, 91, 39}},
        new Student {First="Debra", Last="Garcia", ID=115, Scores= new List<int> {35, 60, 91, 70}},
        new Student {First="Fadi", Last="Fakhouri", ID=116, Scores= new List<int> {99, 86, 90, 94}, Comments = new List<string>{"three","two"}},
        new Student {First="Hanying", Last="Feng", ID=117, Scores= new List<int> {93, 92, 80, 87}},
        new Student {First="Michael", Last="Tucker", ID=122, Scores= new List<int> {94, 92, 91, 91} }
    };
}

private void btnSearch_Click(object sender, EventArgs e){
            
            string connectionString = "Data Source="" I verified correct conn String, it works ";
            string  commandText = "sp_Case_Search";

            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand(commandText, conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandTimeout = 600;
                
                conn.Open();
 cmd.Parameters.Add(new SqlParameter("@Field", SqlDbType.VarChar));

                cmd.Parameters.Add(new SqlParameter("@Field", SqlDbType.VarChar, 50));
                cmd.Parameters.Add(new SqlParameter("@Search", SqlDbType.VarChar, 500));
                
                //add input parameter from stored proc and set value
                
                /*DateTime edtPicker = Convert.ToDateTime(EnterdateDateTimePicker.Value);
                DateTime udtPicker = Convert.ToDateTime(UpdateDateDateTimePicker.Value);
                
                cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Bigint));
                cmd.Parameters.Add(new SqlParameter("@EnterDate", SqlDbType.DateTime)).Value = edtPicker;
                cmd.Parameters.Add(new SqlParameter("@EnterTime", SqlDbType.VarChar)).Value = EnterTimeTextBox.Text;
                cmd.Parameters.Add(new SqlParameter("@EnterBy", SqlDbType.VarChar)).Value = EnterByTextBox.Text;
                cmd.Parameters.Add(new SqlParameter("@CaseTypeID", SqlDbType.Int));
                cmd.Parameters.Add(new SqlParameter("@MethodTypeID", SqlDbType.Int));
                cmd.Parameters.Add(new SqlParameter("@UpdateDate", SqlDbType.DateTime)).Value = udtPicker;
                cmd.Parameters.Add(new SqlParameter("@UpdateBy", SqlDbType.VarChar)).Value = UpdateByTextBox.Text;
                cmd.Parameters.Add(new SqlParameter("@CaseDocNumber", SqlDbType.VarChar)).Value = CaseDocNumberRichTextBox.Text;
                cmd.Parameters.Add(new SqlParameter("@SenderAddress", SqlDbType.VarChar)).Value = senderAddressRichTextBox.Text; */
                
                cmd.ExecuteNonQuery();
                
                cmd.Parameters.Clear();
                conn.Close();

            }

ALTER PROCEDURE [dbo].[sp_Case_Search] 
	-- Add the parameters for the stored procedure here
@Field varchar(50),
@Search varchar(500)

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
    declare @Criteria varchar(502) = '%'+ @Search + '%'
	SELECT 
	   [ID]
      ,[EnterDate]
      ,[EnterTime]
      ,[EnterBy]
      ,[CaseTypeID]
      ,[MethodTypeID]
      ,[UpdateDate]
      ,[UpdateBy]
      ,[CaseDocNumber]
      ,[SenderAddress]
            
    FROM  tblNewCaseEntry
        
    WHERE 
    CASE 
    When @Field = 'ServedBy' then ServedBy 
    When @Field = 'CaseDocNumber' then CaseDocNumber 
    When @Field = 'SenderAddress' then SenderAddress
    When @Field = 'Claim' then Claim 
    End like @Criteria
    ORDER BY EnterDate DESC;
END