- SQL Tutorial
- SQL - Home
- SQL - Overview
- SQL - RDBMS Concepts
- SQL - Databases
- SQL - Syntax
- SQL - Data Types
- SQL - Operators
- SQL - Expressions
- SQL Database
- SQL - Create Database
- SQL - Drop Database
- SQL - Select Database
- SQL - Rename Database
- SQL - Show Databases
- SQL - Backup Database
- SQL Table
- SQL - Create Table
- SQL - Show Tables
- SQL - Rename Table
- SQL - Truncate Table
- SQL - Clone Tables
- SQL - Temporary Tables
- SQL - Alter Tables
- SQL - Drop Table
- SQL - Delete Table
- SQL - Constraints
- SQL Queries
- SQL - Insert Query
- SQL - Select Query
- SQL - Select Into
- SQL - Insert Into Select
- SQL - Update Query
- SQL - Delete Query
- SQL - Sorting Results
- SQL Views
- SQL - Create Views
- SQL - Update Views
- SQL - Drop Views
- SQL - Rename Views
- SQL Operators and Clauses
- SQL - Where Clause
- SQL - Top Clause
- SQL - Distinct Clause
- SQL - Order By Clause
- SQL - Group By Clause
- SQL - Having Clause
- SQL - AND & OR
- SQL - BOOLEAN (BIT) Operator
- SQL - LIKE Operator
- SQL - IN Operator
- SQL - ANY, ALL Operators
- SQL - EXISTS Operator
- SQL - CASE
- SQL - NOT Operator
- SQL - NOT EQUAL
- SQL - IS NULL
- SQL - IS NOT NULL
- SQL - NOT NULL
- SQL - BETWEEN Operator
- SQL - UNION Operator
- SQL - UNION vs UNION ALL
- SQL - INTERSECT Operator
- SQL - EXCEPT Operator
- SQL - Aliases
- SQL Joins
- SQL - Using Joins
- SQL - Inner Join
- SQL - Left Join
- SQL - Right Join
- SQL - Cross Join
- SQL - Full Join
- SQL - Self Join
- SQL - Delete Join
- SQL - Update Join
- SQL - Left Join vs Right Join
- SQL - Union vs Join
- SQL Keys
- SQL - Unique Key
- SQL - Primary Key
- SQL - Foreign Key
- SQL - Composite Key
- SQL - Alternate Key
- SQL Indexes
- SQL - Indexes
- SQL - Create Index
- SQL - Drop Index
- SQL - Show Indexes
- SQL - Unique Index
- SQL - Clustered Index
- SQL - Non-Clustered Index
- Advanced SQL
- SQL - Wildcards
- SQL - Comments
- SQL - Injection
- SQL - Hosting
- SQL - Min & Max
- SQL - Null Functions
- SQL - Check Constraint
- SQL - Default Constraint
- SQL - Stored Procedures
- SQL - NULL Values
- SQL - Transactions
- SQL - Sub Queries
- SQL - Handling Duplicates
- SQL - Using Sequences
- SQL - Auto Increment
- SQL - Date & Time
- SQL - Cursors
- SQL - Common Table Expression
- SQL - Group By vs Order By
- SQL - IN vs EXISTS
- SQL - Database Tuning
- SQL Function Reference
- SQL - Date Functions
- SQL - String Functions
- SQL - Aggregate Functions
- SQL - Numeric Functions
- SQL - Text & Image Functions
- SQL - Statistical Functions
- SQL - Logical Functions
- SQL - Cursor Functions
- SQL - JSON Functions
- SQL - Conversion Functions
- SQL - Datatype Functions
- SQL Useful Resources
- SQL - Questions and Answers
- SQL - Quick Guide
- SQL - Useful Functions
- SQL - Useful Resources
- SQL - Discussion
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 | +----+----------+-------------+