I have just created a database where the info gets input via an online form, I have a column called membershipnumber, this is my sql line:

SELECT membershipnumber, title, firstname, surname FROM members2006 ORDER BY membershipnumber ASC
it was coming out in ascending order ok until entry number 9, when i entered entry number 10 this was positioned between 1 & 2, the Mysql column was created as a text column but will only have numbers entered in it, so why does it see 10 as less than 9, i tried 10. with same resilt.
Please help I am new to this.