REPLICATE

Description

Replicates a string value a specified number of times (REPLICATE in Transact-SQL).

Sample Source Pattern

Syntax

REPLICATE( string_expression, number_expression )

Examples

Code:

IN -> SQLServer_01.sql
SELECT REPLICATE('Staying alive',5) AS RESULT

Result:

RESULT                                                           |
-----------------------------------------------------------------+
Staying aliveStaying aliveStaying aliveStaying aliveStaying alive|

Last updated