Re: Obtain only alphabets from table

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 30 Jun 2004 08:24:32 +0200
Message-ID: <2kf4s9F1i09oU1@uni-berlin.de>

"Reddy" <yyandapa_at_in.ibm.com> schrieb im Newsbeitrag 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

Homework ?
Tip: Try INSTR( ) built-in function

hth, Jan Received on Wed Jun 30 2004 - 01:24:32 CDT