Obtain only alphabets from table

From: Reddy <yyandapa_at_in.ibm.com>
Date: 29 Jun 2004 23:16:14 -0700
Message-ID: <b8d170a3.0406292216.703a9861@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 Received on Wed Jun 30 2004 - 01:16:14 CDT