──SPACE(string─┬─────────────────────┬─)────── └─,──┬───┬─┬────────┬─┘ └─n─┘ └──,pad──┘
SPACE formats the blank-delimited words in string with n pad characters between each word. The n must be nonnegative. If it is 0, all blanks are removed. Leading and trailing blanks are always removed. The default for n is 1, and the default pad character is a blank.
Here are some examples:
SPACE('abc def ') -> 'abc def' SPACE(' abc def',3) -> 'abc def' SPACE('abc def ',1) -> 'abc def' SPACE('abc def ',0) -> 'abcdef' SPACE('abc def ',2,'+') -> 'abc++def'