Tips & Tricks: Renaming a Field

When extracting results to a file, you may want to change the name of some fields that are being extracted. I found this particularly useful after running a join and using this tip to help distinguish which fields belonged to what table.

EXTRACT DocumentNo AS ‘Inv_DocumentNo’ … TO “R_Invoices.fil”

The key is to remember to put single, not double, quotes around the new name you want to give your field.