REPEAT()

REPEAT() returns a string that repeats a constant value a specified number of times.

Use REPEAT() to initialize a variable with constant values or blanks or to set a default value for a computed field. It is useful for advanced programming applications.

Function Format

REPEAT(C,#)

REPEAT() returns a string in which the string C is repeated the number of times specified by #, where # is a fixed numeric constant. The maximum length of the returned string is the length of the string C multiplied by #.

Examples

REPEAT("ABC",3) = "ABCABCABC"

REPEAT("0",9) = "000000000"