RTRIM Function in SQL

This string function truncates the given character or sub-string from the right of the given original string. It also truncates the space from the right of the specified string.

Syntax of RTRIM String Function

Syntax1: This syntax uses the RTRIM function with the column name of the SQL table:

In the syntax, we have to specify the name of that column on which the RTRIM function is to be run.

Syntax2: This syntax uses the RTRIM function with the set of characters (string):

Syntax3: This syntax uses the RTRIM function with a single character:

Examples of RTRIM String function

Example 1: The following SELECT query truncates the given space from the specified string according to the RTRIM function:

Output:

'JAVATPOINT'

Example 2: The following SELECT query truncates the space from the specified string according to the RTRIM function:

Output:

'              JAVATPOINT'

Example 3: The following SELECT query trims the CAPITAL OF INDIA sub-string from the specified string:

Output:

NEW DELHI IS THE

Example 4: The following SELECT query trims the given symbol from the specified string:

Output:

####98221545

Example 5: The following SELECT query trims the given set of numbers from the specified string:

Output:

2021JavaTpoint

Example 6: The following SELECT query trims the given set of numbers from the specified string:

Output:

JavaTpoint

Example 7: The following SELECT query trims all the numbers from the right side of the string which are present in the trimmed string:

This command removes the individual occurrence of numbers of the trimmed string.

Output:

JavaTpoint

Example 8: This example uses the RTRIM function with the table in Structured query Language.

In this example, we use the following Faculty_Info table, which helps to understand the LTRIM string function. The syntax for creating the new table in the SQL database is as follows:

The following CREATE statement creates the Faculty_Info table:

The below INSERT queries insert the records of college Faculties in the Faculty_Info table:

The following SELECT statement displays the inserted records of the above Faculty_Info table: