REPLICATE
Repeats a string value a specified number of times.
Syntax
REPLICATE ( string_expression, integer_expression )
Arguments
string_expression
Is an expression of a character string or binary data type. string_expression can be a constant, variable, or column either character or binary data.
integer_expression
Is an expression of any integer type, including bigint. If integer_expression is negative, NULL is returned.
Return types
Returns the same type as string_expression.
Examples
SELECT REPLICATE('no more sweets ', 3);