REPEAT()
REPEAT() — Returns a string composed of a substring repeated the specified number of times.
Synopsis
REPEAT( string-expression, numeric-expression )
Description
The REPEAT() function returns a string composed of the substring string-expression repeated
n times where n is defined by the second argument to the
function.
Example
The following example uses the REPEAT and the CHAR_LENGTH functions to replace a column's actual contents with a mask
composed of the letter "X" the same length as the original column value.
Documentation