MarkusB (12/17/2008)
You have two options. One is writing your own function which generates new ID's.The second option which I would prefer is using two columns one for location and one for the numeric ID. If necessary you can concatenate both columns when displaying them.
I would agree with Markus that the second option would be preferable with a composite unique index. Of course you still need to do option 1 if you need to partition the numeric portion.
I would question why you need to partition the numeric portion if you are including the location in the id or unique index? Why can't you have JAPA00001 and MYCHIN000001?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question