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





Reply With Quote