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:

SELECT RTRIM(Column_Name, string) AS Alias_Name FROM Table_Name;

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):

SELECT RTRIM(Original_String, trimmed_string);

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

SELECT RTRIM(Original_String, trimmed_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:

SELECT RTRIM( 'JAVATPOINT ',' ');

Output:

'JAVATPOINT'

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

SELECT RTRIM( ' JAVATPOINT ');

Output:

'              JAVATPOINT'

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

SELECT RTRIM( 'NEW DELHI IS THE CAPITAL OF INDIA', 'CAPITAL OF INDIA');

Output:

NEW DELHI IS THE

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

SELECT RTRIM( '####98221545###', '#');

Output:

####98221545

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

SELECT RTRIM( '2021JavaTpoint2021', '2021');

Output:

2021JavaTpoint

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

SELECT RTRIM( 'JavaTpoint202120212021', '2021');

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:

SELECT RTRIM( 'JavaTpoint90287', '0123456789');

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:

CREATE TABLE table_name
(
1st_Column Data Type (character_size of 1st Column),
2nd_Column Data Type (character_size of the 2nd column ),
3rd_Column Data Type (character_size of the 3rd column),
...

Nth_Column Data Type (character_size of the Nth column)
);

The following CREATE statement creates the Faculty_Info table:

CREATE TABLE Faculty_Info
(
Faculty_ID INT NOT NULL PRIMARY KEY,
Faculty_First_Name VARCHAR (100),
Faculty_Last_Name VARCHAR (100),
Faculty_Dept_Id INT NOT NULL,
Faculty_Address Varchar(120),
Faculty_City Varchar (80),
Faculty_Salary INT
);

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

INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1001, 'Arush ', 'Sharma ', 4001, 'Aman Vihar ', Delhi, 20000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1002, 'Bulbul ', 'Roy ', 4002, 'Nirman Vihar ', Delhi, 38000 );
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1004, 'Saurabh ', 'Sharma ', 4001, 'Sector 128 ', Mumbai, 45000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1005, 'Shivani ', 'Singhania ', 4001, 'Vivek Vihar ', Kolkata, 42000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1006, 'Avinash ', 'Sharma ', 4002, 'Sarvodya Calony ', Delhi, 28000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_A

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

SELECT * FROM Faculty_Info;

Faculty_Id	Faculty_First_Name	Faculty_Last_Name	Faculty_Dept_Id	Faculty_Address	Faculty_City	Faculty_Salary
1001	'Arush '	'Sharma '	4001	'Aman Vihar '	Delhi	20000
1002	'Bulbul '	'Roy '	4002	'Nirman Vihar '	Delhi	38000
1004	'Saurabh '	'Roy '	4001	'Sector 128 '	Mumbai	45000
1005	'Shivani '	'Singhania '	4001	'Vivek Vihar '	Kolkata	42000
1006	'Avinash '	'Sharma '	4002	'Sarvodya Calony '	Delhi	28000
1007	'Shyam '	'Besas '	4003	'Krishna Nagar '	Lucknow	35000

The following SELECT query uses the RTRIM function with the Faculty_Last_Name column of the above Faculty_Info table:

SELECT Faculty_Last_Name, RTRIM(Faculty_Last_Name) AS RTRIM_LastName FROM Faculty_Info;

This SQL statement trims the space from the right:

Output:

Faculty_Last_Name	RTRIM_LastName
'Sharma '	'Sharma'
'Roy '	'Roy'
'Roy '	'Roy'
'Singhania '	'Singhania'
'Sharma '	'Sharma'
'Besas '	'Besas'

The following SELECT query uses the RTRIM function with the Faculty_First_Name and Faculty_Address columns of those faculty whose faculty_Id is greater than 1002 in the above Faculty_Info table:

SELECT Faculty_Id, RTRIM(Faculty_Last_Name), RTRIM(Faculty_Address) FROM Faculty_Info WHERE Faculty_Id >1002;

This SQL statement trims the space from the right.

Output:

Faculty_Id	RTRIM(Faculty_First_Name)	RTRIM(Faculty_Address)
1004	'Saurabh'	'Sector 128'
1005	'Shivani'	'Vivek Vihar'
1006	'Avinash'	'Sarvodya Calony'
1007	'Shyam'	'Krishna Nagar'

SQL Tutorial

SQL Database

SQL Table

SQL Select

SQL Clause

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Join

SQL Keys

Difference

SQL Injection

SQL String Functions

Miscl

SQL MCQ

PL/SQL Tutorial

Sql Interview Question

SQl Quiz