HI.
simple (tedious) solution would be do fire 20 sqls. update tabel set f1=<some int 1> where f2='some varchar1'; update tabel set f1=<some int 2> where f2='some varchar2'; update tabel set f1=<some int 3> where f2='some varchar3'; incase there is some the integer is a function of varchar u may translate to the corresponding SQL. regds mallah. > 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. The values of the new column are not important, the important thing is who >can I create > this column and assign a different integer to a different char value in the other >column. > Thanks > -------------- > Javier > > ------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- TIP 4: >Don't 'kill -9' > the postmaster ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
