SQL RTRIM() Function

---

---

The SQL RTRIM() function is used to remove the trailing spaces from the string.

It accepts a string value as a parameter and returns a new string by removing all the trailing spaces from a string. A trailing space is a space that is located after the final character(found on the right side of the word) in a text entry field.

The RTRIM() function returns NULL if we pass NULL values as an argument to it.

Syntax

Following is the syntax of SQL RTRIM() function −

RTRIM(str)

Parameters

• str − It is a string from which the trailing spaces are to be removed.

Return value

This method returns a string after removing all trailing blanks.

Example

In the following example,we are using the RTRIM() function to remove the trailing spaces from the the String ‘hello ‘.

SELECT RTRIM('hello   ');

Output

On executing the above program, it will produce the following output −

+-------------------+
| RTRIM('hello   ') |
+-------------------+
| hello             |
+-------------------+

Example

You can also pass numeric values as an argument to this function as a string.

In the following example, we are passing a numeric value ‘1233 ‘ to RTRIM() function to remove all trailing spaces from it.

SELECT RTRIM('    1232   ');

Output

Following is the output of the above statement −

+----------------------+
| RTRIM('    1232   ') |
+----------------------+
|     1232             |
+----------------------+

Example

Following is another example of the RTRIM() function, here we are passing a string ‘Welcome to TutorialsPoint ‘ to it, this function will remove all trailing spaces from the given string.

SELECT RTRIM('Welcome    to    TutorialsPoint   ');

Output

After executing the above query, it produces the following output −

+---------------------------------------------+
| RTRIM('Welcome    to    TutorialsPoint   ') |
+---------------------------------------------+
| Welcome    to    TutorialsPoint             |
+---------------------------------------------+

Example

If the argument passed to this function is NULL it returns NULL.

In this program, we are passing a NULL value as an argument to the RTRIM() function to remove all trailing.

SELECT RTRIM(NULL);

Output

The above program produces the following output −

+--------------------------+
| RTRIM(NULL)              |
+--------------------------+
| NULL                     |
+--------------------------+

Example

You can also use this function to remove trailing spaces from the values of a column of a table. Let us create a table with name Customers in SQL database using CREATE statement as shown below −

CREATE TABLE CUSTOMERS(    
ID INT NOT NULL,    
NAME VARCHAR (20) NOT NULL,    
AGE INT NOT NULL,    
ADDRESS CHAR (25) ,    
SALARY DECIMAL (18, 2));

Now, let's insert four records in to the Customers table using the INSERT statement as shown below −

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 ); 
INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (2, 'Khilan', 25, 'Delhi', 1500.00 ); 
INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (3, 'kaushik', 23, 'Kota', 2000.00 ); 
INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (4, 'Chaitali', 25, 'Mumbai', 6500.00 );

The following query removes all trailing spaces entities from the contents of the column Name in the Customers table −

SELECT ID,NAME, RTRIM(NAME) FROM CUSTOMERS;

Output

Following is the output of the above query −

+----+----------+-------------+
| ID | NAME     | RTRIM(NAME) |
+----+----------+-------------+
|  1 | Ramesh   | Ramesh      |
|  2 | Khilan   | Khilan      |
|  3 | kaushik  | kaushik     |
|  4 | Chaitali | Chaitali    |
+----+----------+-------------+