Re: Extract the beginning of a string
Date: Thu, 06 Nov 2003 23:32:11 GMT
Message-ID: <_RAqb.131051$HS4.1031371_at_attbi_s01>
Hello Bernard,
You can do it so:
select translate('xyz174',
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789',
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')from dual;
Rgds.
"Bernard Drolet" <le_pul_at_yahoo.ca> wrote in message
news:ee7856eb.0311061513.6c9539e1_at_posting.google.com...
> 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:32:11 CET