SQL TRIM, LTRIM, RTRIM

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'

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