Support 805.461.7300
Sales
NEW SITE. 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

The main reason for this email is to let you know that Geoff is doing a tremendous job for you. He is fast, intelligent, funny, and a hard worker. We had a good time getting the little stuff taken care of and we are back 100% in one day!!!
K.W., Hobe Sound, FL