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

[hrishy]

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