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

Hi,
SELECT * FROM testtable WHERE col3 IN ('A','B','C','D', ... ,'Z') ORDER BY col3

Replace "..." with character you would like to include in SQL.

Hope this helps,
Grofaty

col3 between 'A' and 'Z' will also work, I guess
Sathyaram

Hi,

sathyaram_s this is good idea, but if you have non-english environment you will have to specify also non-english charachters!!! So yug229 if you are from english region then you shoud use sathyaram_s tip, else use my tip.

Hope this helps,
Grofaty