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) |
A.B., Long Island City, NY"You should know and I have told this to many of the people I have spoken to on the phone over the years. All of your employees are always super helpful, knowledgeable and professional every time I need to call in. I always have my questions answered or my issue resolved. Thanks to you and your staff!"
