string query = SELECT mo_no FROM mf_mo WHERE sta_dd = selectedDate and dep like dep; SqlCommand command = new SqlCommandquery connection; commandParametersAddWithValuesel

string query = "SELECT mo_no FROM mf_mo WHERE sta_dd = @selectedDate and dep like '%' + @dep + '%'"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@selectedDate", selectedDate); command.Parameters.AddWithValue("@dep", depValue);