finding the highest version of data in sql server table

Question

Hi allhi i have small doubt.I have table like this column name datatype ----------------- ---------------- date date version varchar(50) name1 varchar(50) date version name1 25/5/2013 1.1 A 25/5/2013 1.2 B 24/5/2013 2.5 C 24/5/2013 2.0 D I want to find the max version record of that day.Can u give me any suggestion abt to find the max vesrion of record?

William Anthony · Answer

hello this query will work with varchar to find select max(version) from table name if version is having numeric/double/float datatype and if you enter strings in the version then it will return first highest charcter having highest ASCII value. you can try: select max(version) from tablename