Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

REPLICATE is used if you wish to replicate the same string several times

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)