>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)