Rpad

String Function

Description

Extends the string to length of length parameter by appending the characters fill (a space by default). If the string is already longer than length then it is truncated.

Click here to navigate to the PostgreSQL docs page for this syntax.

The function Rpad() is supported on Snowflake.

Grammar Syntax

RPAD( string text, length integer [, fill text ] )

Sample Source Patterns

PostgreSQL

Code

SELECT RPAD('12345', 10, 'X');

Result

12345XXXXX

Snowflake

Code

SELECT RPAD('12345', 10, 'X');

Result

12345XXXXX