Example use of the or operator

Use this example to help you use the or operator to combine two search conditions.

The following example shows how to use the or operator to combine two search conditions.

|phoenix:1.> select Name, Age from staff.employees
|phoenix:2.> where Name="Carl" or Name="Matt";
|phoenix:3.> go
..
{
        Name='Matt';
        Age=24;
}
{
        Name='Carl';
        Age=28;
}
( 2 record(s) : Transaction complete )