# What is REPEAT() function in Snowflake ?

Are you looking to find what is the REPEAT() function within the Snowflake cloud data warehouse or maybe you are looking for a solution to use the repeat function in the Snowflake? If you are looking for any of these problem solutions then you have landed on the right page. I will also show you what it is and how to use REPEAT() function. I will explain the REPEAT() function by taking a practical real world examples. So don’t waste time let’s start step by step guide to understand the REPEAT() expression in detail.

## What is REPEAT() Function

REPEAT() function is used to build a string by repeating the given input for the specified number of times.

### Syntax of Repeat function in Snowflake?

```-- Syntax :

REPEAT( input, n)

```

REPEAT() Argument Details :

Input :

A String which is required to repeat the data.

N :

This Argument helps to repeat the input string depending on the given number. If we require string to repeat n number of times, So that string will be repeated n times . The minimum valid number is 0 which will be resulting in empty string.

## How to use REPEAT() Function with Example:

```select repeat('xyz', 5);

-----------------+
REPEAT('XY', 5) |
-----------------+
xyzxyzxyzxyzxyz |
-----------------+

```

As we can see the above example is repeating the given input string for 5 times because here n value is 5.

```select repeat('xy', 0);

-----------------+
REPEAT('XY', 0) |
-----------------+
|
-----------------+

```

As we can see the above example-2 which is resulting as empty string because the number n value is zero (0).

```select repeat('xy ', 5);

-----------------+
REPEAT('XY', 5) |
-----------------+
Xy xy xy xy xy  |
-----------------+

```

## Final Thoughts

In this article we have learned about REPEAT() function and uses with the examples explained clearly. I have also covered different scenario with practical example that could be possible. I hope the information that was provided is helped in gaining the knowledge.

Unicode in Snowflake

Repeat function in Snowflake