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

I just wanted to let your team know how much I appreciate you. I'm still fairly new at doing mail data processing, and it if weren't for your active support -- even for the not so smart questions -- I probably wouldn't be doing as well in this job as I am now. I have much more to learn as I have seen, but I just wanted to say thank you for your help! You all are wonderful!
T.B., Greenville, SC