data type conversion

[cywong119]

Dear All,

I am new in progress.

could anyone tell me how to change a character data type into a integer type in SQL statement?

I have try the following statement, but it fails.

select cint( pub.tableA.fieldA )
from pub.tableA

pub.tableA.fieldA is in character type, I want to change it into integer type for calculation.

Thanks,
Christine

 

[StefGay]

To_number(char_expression)

Read the electronic documentation about SQL92 Functions, it's a good way to learn...