Ordenar Consulta SQL

[DjNelson]

Qué SGBD usas?

Si usas mysql he encontrado un truquete:

Posted by Albert Vega on September 3 2004 11:17pm [Delete] [Edit]

Similar to the above, if you have numbers written in text or characters, and you want to sort them in ascending order and you don't want this:
mysql> select number from (table) order by number;

+--------+
| number |
+--------+
| 1 |
| 10 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+--------+


Use this:
mysql> select number from (table) order by (number+0);

+--------+
| number |
+--------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
+--------+

The (field + 0 ) converts the text/character in the field into an integer.

Es decir, que le sumes 0 al campo para convertirlo en un número.

Saludos.