I need to select maximum of the Emp_id values from SQL server 2005 table.I was using the command which selects max value till 10 but after that it fails to pick max value of emp id from the table.(Actually it picks up Max value using by looking at 1st digit only,so till 9 its fine, but after that it shows 9>11 or 9>57 etc.So please tell me SQL query for finding max value in Emp id column.Thanx.
MY sql query used:-

select MAX(emp_id) from table_name

Ads

View Answers

March 28, 2011 at 2:27 PM

Im guessing that your emp_id column is not a numeric one!

Assuming that it only holds digits, try
select max(convert(int, empid)) from tablename

Or convert the whole column to a numeric type .. in future, it would be helpful if you posted the table definition too!

March 28, 2011 at 2:40 PM

Hi,

Is empid numeric? because '9' is bigger than '11' or '57' if empid string type.So first check that emp_id is numeric or String.