Rather than trying to reinvent the wheel, I was wondering if anyone might
have a stored procedure already for what I want to do.

I want to start with 4 characters using any unique combo and when all
unique matches are used, it will move to 5 characters and so on.

For example in any random order:

AAAA
AAAB
....
ZZZZ
AAAAA
....
ZZZZZ
AAAAAA
....
ZZZZZZ

The codes would be validated for a dupe against an existing column which
this will seed called "code".

Suggestions?


Thanks

Steffan



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql