String Functions MSSQL Tutorial

4>  SELECT REPLICATE("www.rntsoft.com! ",5)
5>
6>
--------------------------------------------------------------------------------
www.rntsoft.com! www.rntsoft.com! www.rntsoft.com! www.rntsoft.com! www.rntsoft.com!
(1 rows affected)