Db2 RIGHT Function

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);
Code language: SQL (Structured Query Language) (sql)

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;
Code language: SQL (Structured Query Language) (sql)

The following shows the output:

RESULT  
------- 
Db2
Code language: SQL (Structured Query Language) (sql)

The following example illustrates how to use the RIGHT() function with a unit:

SELECT  
   RIGHT('Jürgen',5,CODEUNITS16)
FROM
   sysibm.sysdummy1;
Code language: SQL (Structured Query Language) (sql)

This is the output:

RESULT     
---------- 
ürgen
Code language: SQL (Structured Query Language) (sql)

In this tutorial, you have learned how to use the Db2 RIGHT() function to return the number of rightmost characters of a string.

Was this tutorial helpful ?