Support 805.461.7300
Sales
Our Technology. Your Success.

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)

« Back to Commands

As always, thanks for your product. We in the industry TRULY appreciate the fact that YOU get back to us. You have NO IDEA how important that is.
T.G., Berlin, MD