Thanks James - it works fine

Regards . RP .
===============================


James wrote:

> Hi Richard
>
> richard poulin wrote:
>
> > I want to fill a column with unique numbers (let say any unique numbers
> > from a series, ie: between 2000 and 9000) . The column already contains
> > nulls and integers that will be updated by the new numbers. How could i
> > update the whole column with the new values? Thanks
> >
> > RP.
>
> I will be using generator for this one. First ill create a generator
> like gen_uniquenumber, then execute this statement to fill the update
> with the column that has null value this unique numbers.
>
> update tableA
> set columnA = gen_id(gen_uniquenumber,1)
> where columnA is null;
>
> james
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://rd.yahoo.com/SIG=12cj67gou/M=268585.4521611.5694062.1261774/D=egroupweb/S=1705115386:HM/EXP=1079679643/A=1950450/R=0/SIG=124efgk3i/*http://ashnin.com/clk/muryutaitakenattogyo?YH=4521611&yhad=1950450>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>