Jampandu (11/26/2014)

---

Hi Experts,

I need a way to generate some random unique sequences for one of the column (+5 increment for each row)

sequences as below..

A00-A05

A00-A10

A00-A15

…………..

…………..

…………..

A00-A95

A00-B00

A00-B05

…………..

…………..

…………..

A00-Z95

A01-A00

A01-A05

…………..

…………..

…………..

…………..

Z99-Z95

NOTE : Need to exclude alphabet letters like I and O those easy to confuse letters with numbers should not be used in series sequences

Please give me some suggestions or script to implement this.

we are planning to use above series as primary key instead of identity column.

Thanks in advance.