RE: simple sql problem

[Pulikkol Kumar]

Hi
 This will work out ................

SELECT  DECODE(SIGN(x+y-1) , 1,LPAD(TO_CHAR(x+y),LENGTH(x+y),'0'),
                               LPAD(TO_CHAR(x+y),LENGTH(x+y)+1,'0'))  FROM
blah
                                                                                       
               
                                                                                       
               
                                                                                       
               
    Pulikkol Nitheesh Kumar                                                            
               
                                                                                       
               
    Software Engineer                                                                  
               
                                                                                       
               
    Mannai Corporation                                                                 
               
                                                                                       
               
                                C O S - PB # 76                                        
               
                                                                                       
               
                                Doha - Qatar                                           
               
                                                                                       
               
                                Phone : 4412-555 extn                                  
               
                                -363                                                   
               
                                                                                       
               
                                http//www.mannai.com.qa                                
               
                                                                                       
               
                                                                                       
               





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pulikkol Kumar
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).