>Today's Quiz. I want to maximize the number of choices I can assign to a group of records so I choose to use the alphabet through a three character field. How do I programatically increment the next assigned alphabetic character (i.e. AAA, AAB, AAC. .. AAZ then ABA, ABB, etc.)
>
>do I do this with ascii character (chr()) assignments or is there an easier way?
>
you got several answers on how to increment a character field so I won't go into that
but a point to think about
if you are using VFP you may want to consider Integer fields
they are 4 bytes long and give you 2147483648 positive option or twice from that including negative numbers
the advantage this is that this is the fastest data type (for joins etc.)

Arnon