Using an IN list

The following example shows how substitution parameters can be used in an SQL statement to derive an IN list:

select * from g_eczone where

project = '?Project Code?'

and code in (?Zone(s) to include?)

order by project,bhid,depth_from

Substitution parameter setup

Run query with 'Pick Zones' substitution parameter

Whenever you run the query, you will be prompted to select values from the list: