Select MAX(colum) AS name.. ???

[griffith]

I've used this sql:
"SELECT MAX(LangCode) AS LangCode FROM LangTxt"

but, why is 9 always "the max result"?? isn't 10 greater than 9? Can someone tell me how to make it get 10 instead of 9..?

[Anon]

LangCode seems to be a textfield. And in a textfield 9 is literally greater than 10, because the char '9' is higher than the char '1'. End of comparision.

[griffith]

hehe.. I figured 🙂 thanks anyway 🙂