SQLParity

SQL IN list builder

Paste values — get a quoted, escaped IN (…) clause.

Give me
1

Paste your values

One per line, or comma or tab separated.

1 of 6 lines contain commas, so the commas may be part of the values. Check before generating.

Read it as:
2

Your IN clause

6 values

  • 1 value starts with a zero (e.g. "007"), so it is quoted as strings and the zeros are preserved.