>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
Looks like codmodulo is alphanumeric.
If so, transform to numeric before querying (CInt)