I want to pass a list of numbers (as strings) as the lookup ( where invoice_num will be the list of strings ) for a db2 sql query , how do I use the list of strings variable in my sql query ?
can you try something like this
invoice_num_string = String.Join(",", invoice_num)
sql_query = "SELECT * FROM your_table WHERE invoice_number IN (" + invoice_num_string + ")"