hi Mike, use ltrim to left justify and then rpad to pad it out with spaces,
so something like this rpad(ltrim(id), '', 15) id N. :->-----Original Message----- :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :->Behalf Of :->mike mon :->Sent: 27 August 2003 16:09 :->To: Multiple recipients of list ORACLE-L :->Subject: [Q] SQL Help!! How to make select left justify and :->fill space?? :-> :-> :->Can anyone tell me on select how can make it left :->justify and fill space? :-> :->example: :-> :-> ID number(8) :-> :->output: :-> :->12345 Emplyeename :-> ^ :-> |--- fill space :-> :-> :-> :->Thanks. :-> :-> :->__________________________________ :->Do you Yahoo!? :->Yahoo! SiteBuilder - Free, easy-to-use web site design software :->http://sitebuilder.yahoo.com :->-- :->Please see the official ORACLE-L FAQ: http://www.orafaq.net :->-- :->Author: mike mon :-> INET: [EMAIL PROTECTED] :-> :->Fat City Network Services -- 858-538-5051 http://www.fatcity.com :->San Diego, California -- Mailing list and web hosting services :->--------------------------------------------------------------------- :->To REMOVE yourself from this mailing list, send an E-Mail message :->to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in :->the message BODY, include a line containing: UNSUB ORACLE-L :->(or the name of mailing list you want to be removed from). You may :->also send the HELP command for other information (like subscribing). :-> :-> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
