Subject ORDER BY
Author blumache
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...)

I don't know what values are in the field....varchar or numeric

if they are only numerics i want to order by numeric values
if they are numerics and varchar i want to order by varchar values

How can i make that? An example please!!!!