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_Address

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’