Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    48

    Question Unanswered: how to aviode space in beginning and in end


    plz tell me how to avoide blank spaces in beginning and at the end of text field.
    like ' asad' Wrong becz spae is in the beginning
    'asad ' wrong space at the end

    thank


  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Investigate use of the TRIM function.

  3. #3
    Join Date
    Feb 2009
    Posts
    62
    Or, if you're on 8i or earlier, LTRIM and RTRIM

  4. #4
    Join Date
    Jan 2009
    Posts
    17
    select TRIM(' asad ') from dual

    output
    TRIM
    ----
    asad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •