For implicit modification you can use a trigger on the table. If you
wan't store this data, you can use view.
andres javier garcia garcia ?:
>Hi;
>
>I've got a table with two fields and about 3000 rows, the second one is a
>character field, what can have about twenty different values; of c
Hi;
I've got a table with two fields and about 3000 rows, the second one is a
character field, what can have about twenty different values; of course these
values are repeated a lot of times in the table. I need to create a new
column of type integer, whose value depens on the character fields
HI.
simple (tedious) solution would be do fire 20 sqls.
update tabel set f1= where f2='some varchar1';
update tabel set f1= where f2='some varchar2';
update tabel set f1= where f2='some varchar3';
incase there is some the integer is a function of varchar
u may translate to the corresponding
Hi;
I've got a table with two fields and about 3000 rows, the second one is a
character field, what can have about twenty different values; of course these
values are repeated a lot of times in the table. I need to create a new
column of type integer, whose value depens on the character fields. T
