1. Select the Two-parameter Query option in the Query Type group box.

Example:

Select * from customers_rms where customerid >= A and customerid <= F

2. Enter the query information in the Two-parameter Query group box.

3. Table name: The name of the table to be queried (customers_rms in the example).

4. Selected columns: The names of the columns in the answer set, separated by commas. Enter an asterisk (*) to retrieve all columns from the table.

5. Parameter column: The name of the column that contains the parameter (customerid in the example).

6. Low Value: The low parameter value that sets the lower bound of data (A in the example).

7. High Value: The high parameter value that sets the upper bound of data (F in the example).

8. Parameter Data Type (optional): The data type for the retrieved parameter column (may be different from its native data type). If a Parameter Data Type is not selected, the returned data defaults to String.

3. Click the Query button in the Two-parameter Query group box.
   
   

4. The result set from the query appears in the Data Grid.