Sequential number gen function that uses letter A-Z

It came up in a meeting I attended that there is a need to produce up to 36 values per digit of a varchar2(7) column - the 36 values would be 0-9 & A-Z

Would anyone know of how we could do this. Someone from Oracle already mentioned a decode of a sequence - if the number is greater than 9, decode it to A-Z, but that is not the most preferred way to do it, because we'd have to recreate the sequence every time it reached 36 and we would have to do a substring of the generated number in order to know what place to add 1 to. I would like to hear of functions, procedures or other ways we could do this.

Please help us!

Thanks very much in advance

please respond to:
Deborah A. Dawicki
debor19071_at_aol.com or
deborah_at_princetontele.com Received on Thu Aug 01 1996 - 00:00:00 CEST