>>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!!
>
>You could simplify things by using numbers for the revision numbers. Otherwise, if you insist on using A...Y, AA..., you can check for the length as the first criterion, to see whether one revision is higher or lower than the other one. If the length is the same, do a simple string comparison as the second criterion.
>
>HTH, Hilmar.

Hilmar;

Unless the industry has changed - they like to use letters like A-Z and AA-ZZ. We almost made it to AZ more than once! That is a lack of good design. Like designing a product after you produce it. :) Sounds like some programmers I have known! Write code first - define spec never. Spec? What spec? We don't need no stinking spec!

Tom

Tom