SQL-IN.com

SQL IN()

This online tool will make it easy to exchange data between the business and IT.
The business can deliver a list of key numbers from an Excel sheet as an IN string to be used in a SQL query in the database.

SELECT * FROM TABLE WHERE CODE_ID IN (multiple values).

A view options are added for different transformation purposes and types of data.

  • No table data insert needed in production databases
  • No ODBC connection with database needed
  • No Excel scripting macro functions needed
Just email your key list and get corresponding data back from IT. Leading zeros that drop off in Excel can be restored!

Put your list here and in return you will get an WHERE IN(multiple values) string for the SQL database query.
 With quotes for VARCHAR  
 Remove the dots from the NUMBERS  
 Only DISTINCT values  
 Max 1000 per set (ORA-01795)  
 Left padding with 0   to # positions
Trim first # characters
Trim last # characters
Only first # characters
 Remove leading 0  
 Replace   with
 LIKE % at the beginning    LIKE % at the end  

Need more options? Contact : info@sql-in.com