Re: SQL RTRIM function

[Tom Stieger <tom.stieger@xxxxxxxxx>]

Buzz-

Try the following

SET field = REPEAT(' ', LENGTH(field) - LENGTH(RTRIM(field))) CONCAT
RTRIM(field)

I can't test this out, but what I think it should do is repeat spaces for
the amount of spaces trimmed off of the right end of the field, then it
will concatenate the trimmed field to those spaces.

-Tom Stieger


On Mon, Apr 7, 2014 at 9:32 AM, Buzz Fenner <bfenner@xxxxxxxxxxxxxxxx>wrote:

> I have a character field in a large database file where some of the data is
> _not_ right-justified, and needs to be.
>
> I was hoping to do something like this:
>
>
>
> Update library.file
>
> Set field=Rtrim(field)
>
> Where field>'' and substr(field,x,x)=' ' (i.e. last rightmost character is
> blank)
>
>
>
> The statement executes (running as an SQL script in Navigator for i) but
> the
> data is not altered. Is this an improper application of the function?
>
>
>
> --
>
> Buzz Fenner
>
> Business Systems Analyst/Systems Administrator
>
> City Water & Light
>
> 870.930.3374 | 870.219.5229
>
> bfenner@xxxxxxxxxxxxxxxx
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.