SELECT MAX(Field)

[adrian_quah]

Hey guys, i've a query like this: -

SELECT MAX(Rights_ID) FROM Rights_Description

The values in Rights_ID are like say, '1' till '12'...

when i use the query mentioned, i get returned the value '9' instead of an expected '12'...How do i get it to return the Maximum value of '12' and not '9'. I understand the logic since the first digit of both values shows that 9 is bigger than 1 in '12'.

Thanks, gracias amigo! And to a great weekend ahead!

[sfullman]

That's interesting, here's one way even if it's not the most elegant:

SELECT

MAX(

IF(LENGTH(Rights_ID)=1,CONCAT('0',Rights_ID), Rights_ID)

) AS MaxRights

FROM Rights_Description

Should work...
Sam

[Lars_Berg]

If you want to treat it as an integer, change the datatype.

[[deleted]]

Indeed, always store numbers in the proper datatype. In this case, use an INT type.

[adrian_quah]

hey thanks! now i know 2 ways of dealing with this MAX thingy 🙂