highest value of a single character

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
sulen
Forum Commoner
Posts: 79
Joined: Wed Jul 09, 2003 4:55 pm
Location: los angeles
Contact:

highest value of a single character

Post 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
User avatar
sulen
Forum Commoner
Posts: 79
Joined: Wed Jul 09, 2003 4:55 pm
Location: los angeles
Contact:

Post by sulen »

Please ignore my previous post ........ I found the solution. Thanks
Post Reply