RE: Changing justification in a DB field

["Wills, Mike N. (TC)" <MNWills@xxxxxxxxxxxxxx>]

Thanks, that worked. 



Mike Wills
Lawson Programmer/Administrator
Taylor Development
Email: mnwills@xxxxxxxxxxxxxx
Direct Line: (507) 625-3187

-----Original Message-----
From: Vern Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx] 
Sent: Monday, October 13, 2003 2:36 PM
To: Midrange Systems Technical Discussion
Subject: Re: Changing justification in a DB field

Hi. Mike

I've used something like the following:

update file set yourfield = substr('           ', 1, length(yourfield) - 
length(trim(yourfield))) || trim(yourfield)

trim(yourfield) takes off both leading and trailing blanks. The substr() is
of a literal of blanks that is at least as long as yourfield.

HTH

Vern

At 01:43 PM 10/13/2003 -0500, you wrote:
>Hi all, I need to change the justification on a field some are left 
>justified, others are right. Can I do this is SQL? It is a text field, 
>and I need them all right justified.
>
>
>Mike Wills
>Lawson Programmer/Administrator
>Taylor Development
>Email: mnwills@xxxxxxxxxxxxxx
>Direct Line: (507) 625-3187


_______________________________________________
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.