XPost: comp.database.oracle   
   From: chang_dj@yahoo.com   
      
   I am trying to do some analysis on customer's locality, so I'd like to   
   extract numeric part from address.   
      
   Here is how the table looks like   
      
   Table Member   
      
   first_name    last_name    address1                            address2   
   state    zip   
   =======     =======    ===================    =====    ===    ===   
   Tom            whatever        1200 Evelyn Ave, #121   
   CA    94102   
      
   What I want to do is to write some sql to extract 1200 from Tom's address1.   
   Can any one give me some hint? Some sample code will be greatly appreciated   
   !!   
      
   David   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)