View Single Post
Old 08-02-2005, 03:43 PM   #44 (permalink)
MikeGalos
Simplicate!
 
MikeGalos's Avatar
 
Join Date: Oct 2003
Location: Bellevue, WA, USA
Posts: 362
Quote:
Originally Posted by TimMullen
If you just display/sort the "year field" of the VIN and the last four characters, you will get the entries in chronological order.
Actually, that'll only work if the Exige models don't get added and if there are no other changes to the rest of the entries since the year/sn pair are only guaranteed unique if the rest of the items (except checkdigit) remain the same. For example, if they started building some Elise and Exige models for the US in Shah Alam as well as Hethel and have the a/c delete option all eight of the following would be 6/0027:

SCCPC111x6HL30027 which is the 27th 2006 Elise built at Hethel, AC
SCCPC111x6BL30027 which is the 27th 2006 Elise built at Shah Alam, AC
SCCPC111x6HL80027 which is the 27th 2006 Exige built at Hethel, AC
SCCPC111x6BL80027 which is the 27th 2006 Exige built at Shah Alam, AC
SCCPC111x6HA30027 which is the 27th 2006 Elise built at Hethel, No AC
SCCPC111x6BA30027 which is the 27th 2006 Elise built at Shah Alam, No AC
SCCPC111x6HA80027 which is the 27th 2006 Exige built at Hethel, No AC
SCCPC111x6BA80027 which is the 27th 2006 Exige built at Shah Alam, No AC
__________________
2005 Elise BRG, Touring, Hardtop
1991 Elan M100 (for sale)
MikeGalos is offline   Reply With Quote