Hello,

I have a little problem that I would be glad if someone could help me to solve.

I have a table with a number of players, in that table I have all players scores and game difference.

If I do a:" SELECT* FROM player ORDER BY points DESC, gamediff DESC"
I get:
name points goaldiff
playerA 10 15
PlayerB 8 10
PlayerC 6 -5
PlayerD 6 -4

This is wrong in ordinary mathematic because "-5" is less than "-4"
Can I do anything to overcome this problem?

Thanks in advance!

// D_S

probably your goaldiff column is a character column instead of an int column.