MIN incorrect

[Anon]

I'm trying to pull the MAX and MIN values from a mySQL table. Let's say I have the a column called "number" with the following values:

20
100
30
50

SELECT MIN(number) AS low, MAX(number) AS high FROM table GROUP BY id

That will return the following:
low = 100
high = 50

It is obviously determining the MIN and MAX from the first number, not the entire number. Is there a fix for this, or a different way to do it that I'm not aware of? Much thanks in advance.

[veron]

Only reason this would happen is if the 'number' field was a character type (char, varchar, etc.) instead of a numeric (int, float, etc.)
Your fix would be to change the field type.

[Anon]

You are absolutely right, it was defined as a CHAR field. I was looking too hard for what the problem was and overlooked the obvious. Thanks for the reply.