columns, comma, conversion, DB2, excel, IN, mainframe, MAINFRAMES, Operator, queries, query, rows, seperated, SQL, to, values
In our day to day work, we have to run lot of SQL queries. In some cases, we have lot of values that we need to search against a column in the IN operator of the WHERE condition. For this, we need to create the comma separated list of all the values to be used in IN statement. Different people use different ways to convert a huge list of values to a comma separated list.
I specifically use the below attached spreadsheet, where you can provide the list of values in first sheet’s first column. And the next sheets (named with number of values in each row), will have your comma separated values in multiple rows. Which you can copy and paste to the IN operator.
In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog
You may also like to look at: