RE: Changing justification in a DB field

Of course!

MyTable, MyField=char(100)

Update MyTable
Set MyField=
        Substr('(100+ blanks)',1, 100-length(trim(MyField))
)||trim(MyField)

Adjust the 100's to whatever length you have.


> -----Original Message-----
> From: Wills, Mike N. (TC) [mailto:MNWills@xxxxxxxxxxxxxx]
> Sent: Monday, October 13, 2003 2:44 PM
> To: Midrange Systems Technical Discussion
> Subject: Changing justification in a DB field
> 
> 
> 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.
 
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.