Mega Code Archive

 

Categories / MSSQL / String Functions

 

REPLICATE

1> -- REPLICATE: replicate the same string several times. 2> 3> SELECT REPLICATE("www.rntsoft.com",5) 4> GO ---------------------------------------------------------------------- www.rntsoft.comwww.rntsoft.comwww.rntsoft.comwww.rntsoft.comwww.rntsoft.com (1 rows affected) 1>