Page 1 of 1

highest value of a single character

Posted: Tue Sep 14, 2004 3:27 pm
by sulen
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

Posted: Tue Sep 14, 2004 3:29 pm
by sulen
Please ignore my previous post ........ I found the solution. Thanks