Thanks Sergey, I think it would do the trick.

>Check Re: Suggestions for random candidate key generation methodol Thread #902286 Message #902854
>
>>I have this interface to an accounting system.... they have a field for line number wich is char (6). Whent there are more than 999999 records they require to begin with 99999A,99999B,99999C and so on.
>>
>>Do you have any routine to generate those numbers?
>>
>>TIA