From: pedro.lopes@netvisao.pt   
      
   You can use regular expressions on 10g.   
      
   see the documentation at http://tahiti.oracle.com   
      
   bye,   
   pedro   
      
      
   jmaxsherkimer wrote:   
   > i had a basic question on plsql, if i have a variable as varchar2,   
   > containing some text like 'A12345', how do i write a function to make   
   > sure that the first char. is the letter 'A' or 'a' and the next five   
   > characters are numbers?  sorry about asking a basic question, but i'm   
   > not the dba here, he recently left and i'm just the web developer   
   > having to do this for now.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)