Using Or

The effect of using Or between clauses is to expand the range of rows being selected. Rows will be selected if they meet criteria specified in any one of the multiple clauses. The syntax is:

command TABLENAME With clause Or With clause

For example:

List CUSTOMERS With ST = 'CT' Or With ST = 'CA'

Rows to be selected can meet the conditions specified in either With clause.

If the command contains multiple With clauses connected with Or, the system can assume certain defaults. If the With clauses are all searching the same column and using the same comparison, the With clauses can simply "stack up" the comparison values. OpenInsight will assume the default Or and fill in the redundant "With COLUMN" portions of the command.

For example, these two commands are equivalent:

                                                                                                                                                                                                                                                                                                                     
List CUSTOMERS With ST = "CA" Or With ST = "CT"

List CUSTOMERS With ST = "CA" "CT"