how to do select.. into (or maybe insert...into)?

I have 2 tables --

table1(my_rowid integer, col2 anything)
table2(my_rowid integer)

I'd like to copy part of my_rowID from table1 to table2, how can I do that? Do I have to use a cursor for loop? Or I can use select...into or insert...into? I tried a few ways but got no luck :rolleyes:

Thank you and have a nice weekend!

perhaps you should write in pseudo-code what you want

INSERT INTO table2(my_rowid)
SELECT my_rowid/69
FROM table1;

Hi Elaine

How about using the inbuild substr function ? and doing somethin like this

insert into table2
select substr(col1,1,2),col2 from tabl1

regards
Hrishy

P.S:Hope i understood your question right