Re: Obtain only alphabets from table

• Post for FREE via your newsreader at post.usenet.com ****

Hi Reddy

If you work with 10g there is a very simple solution:

select col3 from testtable where regexp_like(col3,'[[:alpha:]]')

Chris

"Reddy" <yyandapa_at_in.ibm.com> wrote in message news:b8d170a3.0406292216.703a9861_at_posting.google.com...
> There is a table name "testtable". This table has three columns
> col1(char), col2(int) and col3(char). The data in the table will be as
> mentioned below:
>
> ------------------------------------------
> Col1 Col2 Col3
> 0 0 0
> 1 1 1
> 2 2 2
> 3 3 3
> 4 4 4
> 5 5 5
> 6 6 6
> 7 7 7
> 8 8 8
> 9 9 9
> a 10 A
> A 11 A
> b 12 B
> B 13 B
> c 14 C
> C 15 C
> ------------------------------------------
>
> How can i get only the alphabets and not numerics from Col3 with the
> order by caluse on Col2?
>
> The result should be as follows:
> A
> B
> C
>
> Please help me out to obtain the result as mentioned above.
> Thanks in advance
>
> Thanks,
> Reddy

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=