Topic group Related topics Example
Returns a string repeated a specified number of times.
The string you want to repeat.
The number of times to repeat the string.
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.