basic plsql question

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. Received on Fri Aug 27 2004 - 07:20:36 CDT