Correct Use of With Keyword

Lists all customers except those in which the ZIP code is 98123.

List CUSTOMERS Without ZIP = 98123

Lists all customers in the state of Connecticut.

List CUSTOMERS With ST = 'CT'

Creates an active list of keys from those customers whose invoice total is greater than or equal to $7,000.

Select CUSTOMERS With INV_TOT GE 7000

Creates a report (sorted by key) of all rows in the MYTABLE table whose key consists of four alphabetic characters (for example, List, Sort, Edit, etc.).

Sort MYTABLE With @ID Matches "4A"

Lists invoices for customers whose city falls within the range of "A" to "D" (inclusive - the cities Atlanta and Detroit would be included in the report).

List INVOICES With CITY Between "A" And "D"

Reports the sum total of the contents of the PRICE column for those invoices in which the city column does not fall in the range "A" to "H" (inclusive).

SumRows INVOICES PRICE Without CITY From "A" TO "H"

Reports the total number of items in the dictionary of the MYTABLE table in which the row.key (@ID) column has an "A" anywhere within it.

CountRows DICT MYTABLE When @ID Contains "A"

Lists all customers in which the state column contains two alphabetic characters.

List CUSTOMERS (With ST Matches '2A')