Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    AU
    Posts
    19

    Question Unanswered: How to cull spaces ?

    i'm sure this will be a ridiculously easy one for most of you...

    I'm using external tables to load a database. However, some of the text fields are right-aligned (ie padded with several spaces).

    How can I get rid of these spaces so that i have a simple character field?

    any ideas would be apprec.

    calico

  2. #2
    Join Date
    Feb 2003
    Location
    AU
    Posts
    19
    actually it's sorted now...

    v_auth := trim(both from p_auth);

    does the trick.

    calico

Posting Permissions

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