Building an IN clause

AQT provides a tool for building a Where clause which uses the IN operator.

And example of such a clause is:

CUSTOMER in ('GIGGLE','GOGGLE','4M')

In some cases one might have a large list of values in the IN list, and the Build IN List dialog makes it easier to manage this.

The Build IN Clause dialog is started by selecting Build IN Clause from the Build Where Clause dialog.

Pasting Values into the Available Values box

The Paste function allows you to add a set of values from the clipboard.

You might use this to, for example, add a list of values you have copied from an Excel worksheet,

When you click on Paste, you will be prompted for the delimiter used for the values you are pasting.