Trimming functions: LTRIM, RTRIM, TRIM

These functions strip space characters from a string. LTRIM strips only from the left side, RTRIM only from the right side, and TRIM from both sides. In all cases the result value is a string identical to the argument except for the possible removal of space characters from either side. Other white space characters, including tabs and newlines, are not removed by these functions:

Varchar LTRIM( value Varchar )

Varchar RTRIM( value Varchar )

Varchar TRIM( value Varchar )

Examples

The following code:

SELECT LTRIM(' Title '),'Author'

returns:

Title ,Author

The following code:

SELECT RTRIM(' Title '),'Author'

returns:

   Title,Author

The following code:

SELECT TRIM(' Title '),'Author'

returns:

Title,Author

Copyright Actuate Corporation 2012