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