lookupSQL example

The following SQL SELECT statement is assigned to the Field object for a Customer ID field in an Orders table:

select CUST_ID, FIRST_NAME || ' ' || LAST_NAME as FULL_NAME from CUSTOMER

The || symbols act as concatenation operators in SQL (like the + operator in dBL). Now when dataLinking to the field or accessing the field’s value, the full name will appear instead of the ID.