When max function is used for integer field the result is based on string. e.g. SELECT MAX(EAML_id) FROM EA_master_list; returns always 9 even table has EAML_id as 10.
Log in to post a comment.