cast to integer?

jamesd0142

ok i have this:

Expand|Select|Wrap|Line Numbers

 
insert into DataSet_Rows 

select rtrim(col01), rtrim(col02) from tempout

col02 is a varchar(50)
but i want it to be an integer how can i do this?

cheers james

dusana

Quote:

Originally Posted by jamesd0142

ok i have this:

Expand|Select|Wrap|Line Numbers

 
insert into DataSet_Rows 

select rtrim(col01), rtrim(col02) from tempout

col02 is a varchar(50)
but i want it to be an integer how can i do this?

cheers james

insert into DataSet_Rows
select cats(col01 as int), cast(col02 as int) from tempout

dusana

Quote:

Originally Posted by dusana

insert into DataSet_Rows
select cast(col01 as int), cast(col02 as int) from tempout

use this
insert into DataSet_Rows
select cast(col01 as int), cast(col02 as int) from tempout

re: cast to integer?