Text to Numbers
Trying to automatically assign a unique number for varying length (40+/-
char) text fields. For example, "Main Street" might return 54580546, whereas
'Broadway' would return 885213369. Numbers would be the surrogate key for
the text. Application is to document data lineage of data elements in a
database, and need to assign a key to elements so that a parent can be
assigned.
thx
|