Navigation:  »No topics above this level«

REPEAT()

Advantage Concepts

Return to chapter overview

Scalar function that returns a string with given characters duplicated 1 or more times.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

REPEAT(<cString>, <nCnt>) à cRepeatedString

Parameters

<cString> The character string to repeat.

<nCnt> The number of times to duplicate <cString>.

 

Return Values

REPEAT() returns a string consisting of <cString> repeated <nCnt> times.

Remarks

<nCnt> must be greater or equal to zero. If nCnt is zero, an empty string is returned.

Note Binary and image fields are not supported by this function. Memo fields are supported by the SQL version of the scalar.

See Also

SPACE()