Skip to main content


1. RPAD Function

The RPAD function in H2 database is used to pad a string value with a specified character to a specified length.

2. Syntax

The syntax for the RPAD function in H2 database is as follows:

RPAD(str, len, padChar)


  • str: The input string that needs to be padded.
  • len: The desired length of the resulting string after padding. If the length of the input string is already greater than or equal to len, no padding will be applied.
  • padChar: The character used for padding the string. It should be a single character or a string of length 1.


  • The RPAD function returns the input string padded with the specified character to the specified length.

3. Notes

  • The str argument is required, but the len and padChar arguments are optional. If not provided, len defaults to 0 and padChar defaults to a space character.
  • If the len argument is negative, the RPAD function will return an empty string.
  • If the padChar argument is an empty string, the RPAD function will return the input string as is.
  • The RPAD function will truncate the input string if its length exceeds the specified len after padding.

4. Examples

Here are a few examples demonstrating the usage of the RPAD function in H2 database:

Example 1 - Padding a string with spaces to a specific length:

SELECT RPAD('Hello', 10) AS padded_string;



Example 2 - Padding a string with a custom character:

SELECT RPAD('Hello', 10, '*') AS padded_string;



Example 3 - Truncating the input string if it exceeds the specified length:

SELECT RPAD('Hello World!', 5) AS padded_string;


  • lpad - Pad a string from the left side.