Please enable JavaScript to view this site.

Vernon CMS Help

Navigation: Advanced Topics > Other Search Methods > Select Statements

Select Statement Components

 Scroll More

Key Words

With

Finds records containing the specified data.

Without

Finds records which do not contain the specified data.

CaseSens

Forces a case sensitive search of the specified data.

For example the following select statements would produce the following results:

Select Statement

Result

WITH LAST_NAME = "Smith"

All Person Records with Smith, SMITH or smith in the Last Name field.

WITH CASESENS LAST_NAME = "Smith"

All Person Records with Smith in the Last Name field. SMITH and smith will not be included.

Presence or absence of data

Select Statements can find records that do or do not contain data in a field.

Select Statement

Result

WITHOUT DEPARTMENT

All Object records that do not contain data in the Department field.

WITH DEPARTMENT

All Object records that do contain data in the Department field.

Comparison Operators

=

Equal to

<

Less than

<>

Not equal to

>

Greater than

]

Starting with

[

Ending with

[]

Containing match

Examples:

WITH CURR_LOC_DATE = "6/12/99"

Will find only objects with a current location date of 6/12/99.

WITH CURR_LOC_DATE < "6/12/99"

Will find objects with a current location date earlier than 6/12/99.

WITH CURR_LOC_DATE <> "6/12/99"

Will find objects with any current location date OTHER than 6/12/99.