In the examples of Adelia condition, the CUSTOMERS entity has logical properties with the following guide words: CCUST_NAME, CCUST_ADDRESS, CCUST_TOWN, CCUST_AREA.
There is also an INVOICE entity with the following fields: FINVOICE_NUM, FCUST_NAME, FINVOICE_AMOUNT.
/* selection of the customer 'SMITH'
*COND(CCUST_NAME = 'SMITH')
/* selection of the customer whose name is held in the variable WNAME
*COND(CCUST_NAME = :WNAME)
/* selection of customers in post code areas 38 and 69
*COND(CCUST_AREA = 38 OR CCUST_AREA = 69)
/* selection of customers whose name begins with 'SM'
*COND(CCUST_NAME STARTS_WITH 'SM')
/* selection of customers whose post code number is held in the variable
/* CCUST_AREA and whose name begins with the characters held in the variable
/* WSTART
*COND(CCUST_AREA = :CCUST_AREA AND CCUST_NAME STARTS_WITH:WSTART)
/* selection of customers whose name begins with S OR T and who live in post
/* code areas 38 or 69
*COND((CCUST_AREA = 38 OR CCUST_AREA = 69) AND (CCUST_NAME STARTS_WITH 'S' OR - CCUST_NAME STARTS_WITH 'T'))
/* case of a join entity between the invoice and client entities, selecting only those
/* lines with an amount greater than the amount in WAMOUNT, where the name begins by
/* S
*COND(FCUST_NAME = CCUST_NAME AND FINVOICE_AMOUNT >:WAMOUNT AND CCUST_NAME - STARTS_WITH 'S')