>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!!

A stab at it would be to would to look at the ascii code for the revision. You could ignore numbers and only convert the character.
CHR('A') = 65
CHR('E') = 69

STR(CHR('A'))+STR(CHR('A')) = 6565
STR(CHR('A'))+STR(CHR('B')) = 6566
STR(CHR('B'))+STR(CHR('A')) = 6665

Something like this may work. The syntax is not 100% but you should get the idea.

HTH