REPLICATE( )

Topic group Related topics Example

Returns a string repeated a specified number of times.

Syntax

REPLICATE(<expC>, <expN>)

<expC>

The string you want to repeat.

<expN>

The number of times to repeat the string.

Description

REPLICATE( ) returns a character string composed of a character expression repeated a specified number of times.

If the character expression is an empty string, REPLICATE( ) returns an empty string. If the number of repeats you specify for <expN> is 0 or less, REPLICATE( ) returns an empty string.

To repeat space characters, use SPACE( ).

The replicate( ) method is almost identical to the REPLICATE( ) function, but in addition to the syntactic difference of being a method instead of a function, the repeat count is optional and defaults to 1.