REPLICATE: replicate the same string several times : REPLICATE « String Functions « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. String Functions
  3. REPLICATE

REPLICATE: replicate the same string several times


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>








Related examples in the same category

1.REPLICATE string
2.REPLICATE('*', 20 - LEN(Name))
3.Use set to assign value to a variable with replicate function