Best format for Unique Number Generation
I am in need of unique numbers for multiple different tables and am wondering what the best format is for the structure. So far I know that I will need to track a letter to correspond to the table...
Forum Discussion
I would put the [Record ID#] portion last and I would suggest for human readability having some dashes or at least a space to separate the elements.
Q-18-03-1234
I would also suggest to zero pad the month like i did above
Q-18-03-1234
I would also suggest to zero pad the month like i did above
Thanks for your reply. Are there any performance, searchability, or other benefits to having the letter in front vs at the end, likewise are there specific benefits to using the record ID at the end vs beginning? I'm just trying to be thorough before I start tracking real data with one format or the other. It seems like the record ID at the front would make drop-down search typing more accurate?