Replicate function in Sql Server - DotNetLogix

Replicate fucntion in Sql server repeats a string for a number of times specified by the user. For example if you want to repeat 'A' five times then just use replication function REPLICATE('A',5). It will produce 'AAAAA' as an output.