Extract the beginning of a string

Hi,

I have a column containing a string; the string always starts with a letter (a-z), followed by an undefined number of letters, then one number or more.

The REGEXP would look like [a-zA-Z][a-zA-Z]*[0-9]+

I need to extract the letters at the beginning in an SQL query or in PL/SQL For example, If I have

abc123 -> abc

a123 -> a

abcdefgh1 -> abcdefgh

Any suggestion ?

Thank you

Bernard Drolet Received on Fri Nov 07 2003 - 00:13:20 CET