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
Re: Trim Function in various Databases
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.