SQL Server – REPLICATE function (repeat string N numbers of times)
REPLICATE function this is one of the sql server string functions.
This function repeat string or char N number of time
REPLICATE ( string_expression ,integer_expression )
Example.
DECLARE @st VARCHAR(10)='@1';
SELECT Replicate(@st,4)
The result.
@1@1@1@1