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 understand why the USPS needs to change things over time, but since they don't have to deal with customers' software they often don't care about the downstream effects. You guys do a great job on both fronts.
J.P., Greenville, NC