Hi,

> I have a VARCHAR field, name COD. If the column have only numeric
> vaues, i want to order this field like numeric value (1, 2,
> 3, ...10, 100), not like varchar (1, 10, 100, 2...)
>
>
> How can i make that? An example please!!!!

Perhaps with:

select cast(cod as integer),
...
from ...
order by 1

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com