Creating a text string from multiple cells of data

[kc_native]

I have been tasked with doing a database search of a list of part numbers some 3,300 items long. In order to search the database, I have to enter the part numbers in SQL code in the following format: ('number','number','number',......). I am hoping that there is some code that someone can suggest that will take the contents of each cell in a column, and put them together in that format in a single cell. It is my understanding that there is a capacity of 32,767 characters per cell in Excel 2010, so there should be enough room for my 3,300 cells of part numbers, which average 8 characters each.

Any help would be greatly appreciated.

 

[Ron Coderre]

If you can give more information, we may be able to figure out an efficient way to do what you need.
• What kind of database are you querying? (MS Access, SQL Server, Oracle, other?)
• What tool are you using to perform the query?

 

[kc_native]

If you can give more information, we may be able to figure out an efficient way to do what you need.
• What kind of database are you querying? (MS Access, SQL Server, Oracle, other?)
• What tool are you using to perform the query?

It is an Oracle database, and I am using a query that was written in SQL Developer to query the database. The relevant line in the query is as follows:

and ob.tool_no like '%number%'  ("number" is the variable part I am searching for)

 

[Ron Coderre]

Do you really need the wildcards in the LIKE clause? Or would the ob.tool_no actually match an item in your list?

 

[kc_native]

Do you really need the wildcards in the LIKE clause? Or would the ob.tool_no actually match an item in your list?

The wildcards are there because we have parts with the same base number, but a different prefix or suffix, and we might want to search for all possible combinations.