the idea is to create a unique identifier for a scancode. we want to keep the value short, (less tha 5 characters) but have a large array of values,...

I know that this is an old posting, but this function is exactly what I ws looking for...Thanks!!

I actually think this might work!!

I also found a sample of a function that takes a string and increments the alpha numeric string by 1.

a trigger on the table calls...