highest value of a single character
Posted: Tue Sep 14, 2004 3:27 pm
I have a table in which a particular column contains the values 'A' 'B' 'C' 'D' and so. I want to return the highest chararcter entry like out of A, B, C and D it should return D.
I know select max(col_name) works perfectly in the case of numbers but I wanted something similar in the case of alphabets. Thanks
I know select max(col_name) works perfectly in the case of numbers but I wanted something similar in the case of alphabets. Thanks