Re: Challenge: algorithm to transform unique string into unique number

It's for an actual project at real company :)

can't be homework.. fall sem/quarter hasn't started at most school. Way too early for a final ;)

I found a simpler solution.. but still curious how you'd do that..

thanks.

"Alan" <alan_remove_this_shein_at_erols.com> wrote in message news:<ak64lp$1fhm3p$1_at_ID-114862.news.dfncis.de>...
> Is this homework, or for a final exam?
>
> "upuaut" <upuaut_at_yahoo.com> wrote in message
> news:c1a86e59.0208231013.7608106a_at_posting.google.com...
> > Group A (we) has a database with few tables that maintains
> > demographics and survey responses of a list of users. A user is
> > identified by their (type text) user_id . Each of course have their
> > own unique one.
> >
> > The challenge: We (group A) need to feed out survey data into a nother
> > database maintained by group B (them) that uses a number as a unique
> > identifier for the user_id. Is there a way I can generate a *MAGICAL*
> > unique number for every user from the user_id?
> >
> > Also, we should be able to get the user_id from the generated number.
> >
> > The login ID is varchar2(100)
> > The number to be generated is Number(20)
> >
> > Any help/pointers is/are appreciated.
> >
> > thanks.
Received on Sun Aug 25 2002 - 19:49:38 CDT