SQL TRIM Function - SQL LTRIM, RTRIM Functions

• « SQL Functions

SQL TRIM Function

SQL TRIM function remove all specified trim char from beginning and ending of the string.

Supported Oracle SQL Version

• Oracle 8i
• Oracle 9i
• Oracle 10g
• Oracle 11g
• Oracle 12c

Syntax

TRIM( 
    [ 
        [ LEADING | TRAILING | BOTH ] 
        trim_character FROM 
    ] string 
)

Parameters

• LEADING remove trim_character from beginning of the string.
• TRAILING remove trim_character from ending of the string.
• BOTH remove trim_character from both beginning and ending of the string.
• trim_character specified the trim character that you want to remove from the string. If you not specify TRIM function remove spaces from string.
• FROM is a keyword.
• string original string that we want to trim.

Example

Consider following example how to TRIM function remove specified character.

SQL> SELECT TRIM(LEADING 'N' FROM 'NOpal Kole') "LEADING TRIM" FROM DUAL;

LEADING TRIM
------------
   Opal Kole

SQL LTRIM Function

SQL LTRIM function remove all specified trim char from left side of the string.

Supported Oracle SQL Version

• Oracle 8i
• Oracle 9i
• Oracle 10g
• Oracle 11g
• Oracle 12c

Syntax

LTRIM(string, trim_char)

Parameters

• string is string that string you want to trim from left side.
• trim_char is specified char that character you want remove from the string.

Example

Consider following example remove all specified trim char from left side of the given string argument.

SQL> SELECT LTRIM('2254Opal Kole', '2254') "LTRIM" FROM DUAL;

LTRIM
---------
Opal Kole

SQL RTRIM Function

SQL RTRIM function remove all specified trim char from right side of the string.

Supported Oracle SQL Version

• Oracle 8i
• Oracle 9i
• Oracle 10g
• Oracle 11g
• Oracle 12c

Syntax

RTRIM(string, trim_char)

Parameters

• string is original string.
• trim_char is specified char that character you want remove from the string.

Example

Consider following example remove all specified trim char from right side of the given string argument.

SQL> SELECT RTRIM('Opal Kole2254', '2254') "RTRIM" FROM DUAL;

RTRIM
---------
Opal Kole

• « SQL Functions