To "attempt" to guarantee uniqueness you could try hashing, but it's one way only and you might get clashes.
On Tue, 14 Mar 2023, 9:55 am Tom P via ozdotnet, <ozdotnet@ozdotnet.com> wrote: > Hello > > I was hoping some of the SQL experts here could help with a problem I am > facing. Currently have covid too so perhaps I'm not thinking clearly... > > Long story short, is there a way in SQL Server to convert > strings (varchars) of any length to exactly 32, keeping uniqueness? It > would also be nice if I could convert them back to ensure I haven't lost > information. > > Briefly, the reason I want to do this is my target is varchar(32) but the > IDs I am dealing with are made up of composite business keys of larger > length. I need to be able to use the current business keys and generate > unique 32 character equivalents in a deterministic way. > > Appreciate any advice. > > Thanks > Tom > -- > ozdotnet mailing list > To manage your subscription, access archives: https://codify.mailman3.com/
