convert char type field to int type field

[shanghai2004]

Hi,

I have a char type field in a table. The field contains charactors from 0 to 9. Now I need to convert this field to a int type field since the field only contains digits.

Is there a easy way to do it?

Thanks

 

[DrSql]

cast(fieldname as int)

Dr.Sql
Good Luck.