When integer is stored in VARCHAR field. If numbers are stored in VARCHAR field then MAX command will return based on the first digit. Example. SELECT MAX ( t1) from max_value We stored these number in t1 ( VARCHAR ) column , 1,2,3,4,5,6,12,13.