Center data in a field
In case you want to center the data in a field, perhaps for the purpose of exporting your data in a centered format, this expression centers the field named First in a 75 character line
SPACE((75-LEN(ALLTRIM(FIRST)))/2)+ALLTRIM(FIRST) |