UPPER( ) example

UPPER( ) is frequently used to make searches case-insensitive. First you create an index using UPPER( ), for example:

index on upper( LAST_NAME - "," - FIRST_NAME ) tag FULL_NAME

Then when searching, convert the search value to uppercase to match:

seek upper( form.search.value )