Thread: Trim Function in various Databases

DB2 --> ltrim, rtrim

SQL Server --> ltrim, rtrim

Oracle --> trim with leading, removes any leading characters equal to trim_character.

trim with TRAILING, removes any trailing characters equal to trim_character.

MySQl --> ltrim, rtrim

basically it's LTRIM and RTRIM in all Databases except Oracle

These string functions were designed to be compatible with functions specified in the ANSI SQL '92 standard and functions used in ORACLE.

In cases where the ANSI SQL '92 standard and the ORACLE functions were not compatible (such as the LTRIM and RTRIM in ORACLE versus TRIM in the ANSI standard), both versions were implemented.