How to Use the RTRIM() Function in SQL Server: A Complete Guide

Syntax:

<span class="pln">
RTRIM</span><span class="pun">(</span><span class="typ">Character_Expression</span><span class="pun">)</span><span class="pln">
</span>

Removes blanks on the right hand side of the given character expression.

Example: Removing the 3 white spaces on the left hand side of the 'Hello ' string using RTRIM() function.

Code:

<span class="pln">
</span><span class="typ">Select</span><span class="pln"> RTRIM</span><span class="pun">(</span><span class="str">'Hello   '</span><span class="pun">)</span><span class="pln">
</span>

Output:

The above code will produce the following result-

<span class="pln">
</span><span class="typ">Hello</span><span class="pln">
</span>

Example: To remove white spaces on either sides of the given character expression, use LTRIM() and RTRIM() as shown below.

<span class="pln">
</span><span class="typ">Select</span><span class="pln"> LTRIM</span><span class="pun">(</span><span class="pln">RTRIM</span><span class="pun">(</span><span class="str">'   Hello   '</span><span class="pun">))</span><span class="pln">
</span>

Output:

The above code will produce the following result-

<span class="pln">
</span><span class="typ">Hello</span><span class="pln">
</span>