Use AS along with quotation marks to change the name of a resulting column to make the output of the query make more sense.

The example below shows the original query language that has been replaced by the new strings to account for the renaming of the columns:

SELECT

ZUSER

ZUSER AS “User”,

ZTIMESTAMP,

ZTIMESTAMP AS “Timestamp”,

ZBODY,

ZBODY AS “Message”,

ZRECEIVEDTIMESTAMP,

ZRECEIVEDTIMESTAMP AS “Message Received”

FROM ZKIKMESSAGE

*Strikethroughs represent the original query. The new query language with applied column names appears directly below.