Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove Trailing Spaces From Text Field? (A2k (9.0.3821) SR-1)

    Remove Trailing Spaces From Text Field?
    A2k (9.0.3821) SR-1

    After conversion from legacy system I notice some of my text fields have x number of trailing spaces after the value.

    How do I structure an upgate query to remove trailing spaces after the value in the text field?

    Thanks, John

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remove Trailing Spaces From Text Field? (A2k (9.0.3821) SR-1)

    I would use the Trim function. You could use RTrim, but in my experience, leading spaces sometimes creep in as well, and Trim removed both leading and trailing spaces. The SQL would be something like this:

    UPDATE Customers SET Customers.CompanyName = Trim([CompanyName]);
    Charlotte

Posting Permissions

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