Hello i have a database in Mysql and i have the next elements of a recordset (4,6,10,7) and i use the next query to use it:

select codmodulo from modasg where cod=123 order by codmodulo desc

the result for this recordset is: 7,6,4,10

if i use the order by codmodulo asc the result is 10,4,6,7
but the real result i need is 4,6,7,10. How can i sove this out?

Thanks for the help.