# RPAD

Uses a given padstring to right pad a string to a certain size.

## Syntax

```
RPAD(STRING, SIZE, PADSTRING)
```

## Arguments

#### STRING

Type: `string`

The string to be padded.

#### SIZE

Type: `bigint`

A non-negative integer specifying the length of the result string.

#### PADSTRING

Type: `string`

The string to use for padding. This must be non-empty.

## Returns

Type: `string`

`STRING` right padded to `SIZE` with `PADSTRING`.

If `SIZE` is less than the length of `STRING`, the result is truncated to `SIZE` characters.

***

## Examples

| STRING | SIZE | PADSTRING | Output |
| --- | --- | --- | --- |
| Call me Ishmael. Some years ago | 7 |  | Call me |
| drizzly November | 16 | . | drizzly November |
| right | 1 |  | r |
| what | 9 | ?! | what?!?!? |
| `null` | 9 | `''` | `null` |
| hi | 5 | five | hifiv |