Specifying Search Criteria

...

Distribution

IS User

Related Procedures

Using Query Mode

Ownership

The Training Manager is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

IS Form
M ® View ® Query by Example ® Enter
Expenditure Batches

Using Query Operators

Operator	Meaning	Example
=	Equal to	= ‘Janet’ or = 107
!=	Not equal to	!= ‘Janet’ or != 107
>	Greater than	>99.1 or > ‘Joan’
>=	Greater than or equal to	>=55
<	Less than	<1000.00
<=	Less than or equal to	<= 100
#BETWEEN	Between two values (numeric values are inclusive)	#BETWEEN 1 and 100

Using Wildcard Characters

You can use the percent “%” wildcard character to represent any character or group of characters. For example, use “A MEH9D 01%” to represent A MEH9D 010525 001, and so on. You can also use the underline “_” character to represent any single character. For example, “A MEH9D_%01” can represent A MEH9D 040205 001, or A MEH9D 050401.

Effective: 08/13/04

Revision: 2

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.