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

Just wanted to say THANKS!!!!!!! Great training session and I ran another list this afternoon, no issues!!!! You ROCK!!!! I am just so pleased with AccuZIP...Donna and Crissy are wonderful and everyone is so helpful! Very refreshing in these times!!! THANK YOU AGAIN!!!!
L.B., Englewood, FL