Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: Removing Unused Fields


    I have a varchar(100) field where a user can enter text. However there is often no need for the full 100 characters.
    Is there any way to remove the unused character at the end of the text?
    I tried "Set Trimspool On" but it didn't seem to do anything.

    Any help gratefuly received.

  2. #2
    Join Date
    Feb 2004
    Dublin, Ireland
    what you mean "to remove the unused character at the end of the text"?

    are values in your text column filed up with empty chars? it means is length() of your text = 100 even if it contains less then 100 "not white" characters?

    in this case use trim function when inserting values into table
    insert trim(v_text) into table;
    you can handle this in your application or by trigger

Posting Permissions

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