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

    Unanswered: Removing Unused Fields

    Hi

    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
    Location
    Dublin, Ireland
    Posts
    212
    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
    Code:
    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
  •