Db2 query passing a list of strings as an variable

[hannahscott216 (Hms216)]

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 ?

[muktadir]

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 + ")"