Results 1 to 2 of 2

Thread: Trim Function in various Databases

  1. #1
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    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


  2. #2
    Junior Member
    Join Date
    Mar 2007
    Answers
    1

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact