![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Operators are used in conjunction with primary commands to narrow the scope of the command. The following operators are available:You can connect several conditions in a command using the operator AND (or the symbol &). AND means that the conditions before and after the AND are both included in the search criteria.Type find manager='simons' and deptno=10 to locate those employees whose manager is Simons and who work in department 10.You can use the operator OR (or abbreviation |) to connect several conditions. OR means that condition one is true, condition two is true, or both conditions are true.Type select manager='simons' or deptno=10 to select those employees, regardless of their department, whose manager is Simons, and all those employees who work in department 10.Those employees who have Simons as a manager and are in department 10 are selected only once.
• Type find deptno=30 to locate employees who are in department 30.
•
• Type find salary>=986.73 to locate all salaries that are greater than or equal to $986.73.You can use LIKE to perform partial matches when using SELECT or FIND. The string that you use must be enclosed in single quotation marks.
The following are some examples of inquiries that use LIKE and wildcards in a FIND command. In these examples, only the first employee is found. To find more employees, use the Find Next PF key (PF5) or use a SELECT to find all employees that match the selection criteria:
• Type find lname like 'C*' to locate the first employee whose last name begins with C, regardless of how many characters follow the C.
• Type find lname like '????G' to locate the first employee whose last name is five characters long and ends in G.
• Type find lname like '?H*LD' to locate the first employee whose last name has H as the second character and LD as the last two characters.
• Type find deptno=50 and lname like '?I*' to locate the first employee of department 50 whose last name has I as the second character.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |