|
First of all, these aren't going to be "auto"-incremented.
If you're hoping to have the database generate these codes
automatically, it's not going to happen. The best you can do is
generate these codes yourself. Start by creating a LETTERS table:
create table letters
( letter char(1) not null primary key
);
insert into letters values
('A'),('B'),('C'),('D'),('E'),('F'),('G')
,('H'),('I'),('J'),('K'),('L'),('M'),('N')
,('O'),('P'),('Q'),('R'),('S'),('T'),('U')
,('V'),('W'),('X'),('Y'),('Z');
Now you can easily generate any range of codes like this:
select t1.letter||t2.letter
from letters as t1
cross
join letters as t2
where t1.letter||t2.letter
between 'AA' and 'BA'
Simple, eh?
|
