Mahmoud ElMansy: knowledge meant to be free

19 May 2013

by ElMansy

No Comments

SQL Functions, SQL Server, tips & tricks

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