populating colums from other columns

[silver40]

Hi.

Is there a way that I can create a column that will hold the first two characters of the values from another column ?

The existing column already has populated rows. I just need to take the first two characters of the values of this column and populate another column in the same table.

I hope I didn't confuse anyone.

Please anyone help. THANKS

By the way, I'm running Oracle8i on Linux.

[ales]

Hi,
no matter where's you Oracle running:

update your_table
set new_column=substr(another_column,1,2);
commit;

to add a column to the table:

alter table your_table add new_column char(2);

HTH,
Ales

[silver40]

Thanks. It works perfect.