SQL TRIM

The SQL Trim feature is are functions (LTRIM and RTRIM) that remove leading and trailing blanks from a string.

For example, the function LTRIM(' Minnesota') returns:

'Minnesota'

The SQL Trim functions (LTRIM and RTRIM) are useful in cleansing data that contains leading and trailing blanks.

SQL TRIM is used as follows.

SQL TRIM Syntax

SELECT LTRIM(<value_1>)

SELECT RTRIM(<value_1>)

SQL TRIM Example

The LTRIM function removes the leading blanks in the string ' Bob'.

This SQL Statement with LTRIM is executed:

SELECT LTRIM(' Bob ') as trimmed_string

Here is the result.

trimmed_string

Bob

trimmed_string
Bob