Re: String Right justification

Posted in 2006

=?iso-8859-1?q?Rich_or_Krist=EDn?= — 13 Jun 2006 01:17:44 -0700 — source: Usenet: comp.databases.informix

Nirmala Kesavan wrote: > Hi, > Can anyone tell me how right justification can be done in string > > > Regards > Nirmala SELECT SUBSTR(LPAD(someColumn,10,' '),-10,10) FROM myTable; In this example I've justified the string with spaces and ensured the total length of the returned string will be 10, I'll leave it to you to make it more generic etc. but there's more than enough to get you started ;-) Rich