Replicate function in SQL Server

The REPLICATE () function repeats a string a specified number of times.

Syntax

REPLICATE (string, integer)

The < string > is an expression of a character string or binary data type.  The < integer > is an expression of any integer type, including BIGINT.  If < integer > is negative, a NULL string is returned.

See the example:

If we will give negative value then it will return a null value.