My table has a column whose values is a text string of about 60 characters. I'm using this column as a unique identifier for the row. It would be convenient if I could convert this string into something shorter and still unique. Does anyone know of a way to do that?
The text string includes hyphens and other punctuation characters, but I can strip those out if the compression method only works on alphanumerics.
Thanks.
Bookmarks