>I have a table that lists engineering drawings and their revisions. The list can have the same drawing number listed several times with different revision levels. I need to find the highest revision. This seems simple until you consider that a revision E is higher than an E2 because E2 was a temporary change that was incoporated into the E change. One more complication is when the drawing is revised behond revision Y(we din't use Z) the next revision is AA. So it dosen't seem a simple solution will work. Please Help!!

I thought I had a solution but it seems that your E2 revision throws a wrench into it. Is this a correct revision history (or would that be a revisionist history...hmm...)?

A
B
C
D
E2
E
..
Z
AA

If this is correct and you didn't have the E2 you could just right-justify the field and sort it.

A
B
C
D
E
..
Z
AA

That E2 really messes things up IMO.