That page doesn't exist. Search or drop a file below to find the tool you need.
What do you need to get done?
Drop a file here
or .
/
Open an app
Follow a recipe
Use one tool
Turn a column of IDs into a quoted list for a query
A column copied from a spreadsheet becomes 'a', 'b', 'c' for the IN ( ) of a database query, without doubles or stray spaces.
The steps
- Take out the doubles. Each ID stays once.
- Trim the spaces. Spaces before and after each ID go.
- Add quotes and commas. Copy the list into your query.
A quoted, comma-separated list.
People also search for
- list to sql in clause
- add quotes and commas to list
- column to comma separated quoted
- ids for sql query