SQL Server Transact Basic to Expert - Repeating a string N number of times

Karthikeyan Anbarasan
13y
2.8k
0
0

Blog

This blog shows how to repeat a string N number of times using REPLICATE in SQL Server

Syntax:

REPLICATE ( characterexpression ,integerValue )

Example:

SELECT REPLICATE ('A', 5)

The expected result would be like AAAAA

SQL Server Transact Basic to Expert - Repeating a string N number of times

Up Next

SQL Server Transact Basic to Expert - Stuffing string into a string

Ebook Download

View all

Introducing Microsoft SQL Server 2016

Read by 11k people

Download Now!

Learn

View all