Db2 RIGHT()
function returns a substring that consists of the specified number of rightmost characters from a string.
The following shows the syntax of the RIGHT()
function:
LEFT(string, length, unit);
In this syntax:
- First, specify the source string (
string
) from which substring is extracted. - Second, specify the number of rightmost characters (
length
) to be extracted. - Third, optionally specify the unit of the
length
with the value in the following table.
Unit | Description |
---|---|
CODEUNITS16 | Specifies that the length is expressed in terms of 16-bit UTF-16 code units. |
CODEUNITS32 | Specifies that the length is expressed in terms of 32-bit UTF-32 code units. |
OCTETS | Specifies that the length is expressed in terms of bytes. |
This example returns the first three characters of the string 'IBM Db2'
:
SELECT
RIGHT('IBM Db2',3) result
FROM
sysibm.sysdummy1;
The following shows the output:
RESULT
-------
Db2
The following example illustrates how to use the RIGHT()
function with a unit:
SELECT
RIGHT('Jürgen',5,CODEUNITS16)
FROM
sysibm.sysdummy1;
This is the output:
RESULT
----------
ürgen
In this tutorial, you have learned how to use the Db2 RIGHT()
function to return the number of rightmost characters of a string.