CENTER/CENTRE


>>-+-CENTER(-+--string,length--+------+--)---------------------><
   '-CENTRE(-'                 '-,pad-'

returns a string of length length with string centered in it, with pad characters added as necessary to make up length. The length must be a positive whole number or zero. The default pad character is blank. If the string is longer than length, it is truncated at both ends to fit. If an odd number of characters are truncated or added, the right-hand end loses or gains one more character than the left-hand end.

Here are some examples:

CENTER(abc,7)               ->    '  ABC  '
CENTER(abc,8,'-')           ->    '--ABC---'
CENTRE('The blue sky',8)    ->    'e blue s'
CENTRE('The blue sky',7)    ->    'e blue '

To avoid errors because of the difference between British and American spellings, this function can be called either CENTRE or CENTER.