RTRIM Function in SQLThis 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 FunctionSyntax1: 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 functionExample 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:
|
The following SELECT query uses the RTRIM function with the Faculty_Last_Name column of the above Faculty_Info table:
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:
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' |