<<<<<<< HEAD right | H2 | SQLDoc
Skip to main content

right

1. RIGHT Function​

======= right | H2 Function | SQLDoc

right

1. RIGHT Function​

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

The RIGHT function in H2 database is used to extract a specified number of characters from the right end of a given string.

2. Syntax​

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

RIGHT(string, length)

Arguments​

  • string: The input string from which characters need to be extracted.
  • length: The number of characters to be extracted from the right end of the string.

Return​

  • The RIGHT function returns a substring containing the specified number of characters from the right end of the input string.

3. Notes​

  • The RIGHT function is case-sensitive. It extracts characters from the right end of the string as it is, without considering the case.
  • If the length is negative, the RIGHT function returns an empty string.
  • If the input string is NULL, the RIGHT function will also return NULL.

4. Examples​

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

Example 1 - Extracting the rightmost 3 characters from a string:​

SELECT RIGHT('Hello World', 3) AS result;

Output:

result
------
rld

Example 2 - Extracting a specified number of characters from a column:​

CREATE TABLE names (
  id INT PRIMARY KEY,
  name VARCHAR(50)
);

INSERT INTO names VALUES (1, 'John Doe'), (2, 'Jane Smith'), (3, 'Michael Johnson');

SELECT id, name, RIGHT(name, 5) AS result
FROM names;

Output:

id | name            | result
---+-----------------+--------
1  | John Doe        |  Doe
2  | Jane Smith      | Smith
3  | Michael Johnson | hnson
  • left - Extract characters from the left end of a string.
  • substring - Extract a substring from a string with more flexibility.