ORDER by on varchar field

[lhg1]

Hi

I want to order by a field - that contains a number. But the DB field is a varchar insted of an intiger.

This is my sql

select field1, field2 
from table
order by field1

the result is

field1 field1
1 the first
10 number ten
2 the secound.

it should be

field1 field1
1 the first
2 the secound.
10 number ten

Does anyone know how to sort by number?

Thanks
LHG

 

[Jamfool]

Try:

order by CAST(field1 AS INT)

 

[lhg1]

Excelent - it works.

Thanks

LHG