-
Contributing Member
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
-
Junior Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules