Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
The gist of the problem is that GM treats the vehicle attributes section (position 4,5,6,7) differently depending on whether it is a truck or a car. Normally what I do is design my own crude ETL process to import the data into an RDMBS - each table roughly correlates with the major VIN breakdown.
To look up a VIN is simply a matter of querying the VIEW with each major character code position breakdown of the VIN string. Having worked in this industry, first, asking a question like this on SO is way out of the ballpark.
Based on your answer to my comment regarding if you can identify the type of vehicle by using other values, a possible approach could be to have a master table with the common fields and 2 detail tables, each one with the appropriate fields for either cars or trucks.
As for DML SQL you would only need to control prior to insert or update sentences whether you have a car or a truck model.


Of course you would need to make sure that only one detail exists for each master row, either on the car detail table or on the truck detail table. Sign up for our newsletter and get our top new questions delivered to your inbox (see an example).
Why you do not define both of these rules for the decoding; only one will resolve a valid result. Not the answer you're looking for?Browse other questions tagged sql database-design or ask your own question. Why does Uncle Bob suggest that coding standards shouldn't be written down if you can avoid it?
How To Decode a VIN  Prior to understanding how VIN decoding works, it is important to know what it is all about.
IMHO it would be better to return different data structures for cars, trucks, motorbikes, caravans, etc.


There are common elements that they all share (weight, number of wheels, colour, etc.) but you should model it on what is in the real world. The formal VIN started in 1981 since before that there were different formats used by different manufacturers. The standardization of the numbers was done to get rid of chances of similar VIN’s appearing. The digits that are found on car VIN indicate the year the vehicle was manufactured, assembly point, country of origin, model as well as other important details that will prove helpful in its identification.



Free online sms job without investment
Verizon cell phone plans family
How to find my iphone 5 using icloud


Comments to «How to look up a car by vin number for free history»

  1. Sevgi_Qelbli on 31.01.2014 at 13:56:24
    Don't remember the IMEI quantity of your mobile telephone.
  2. yjuy on 31.01.2014 at 11:23:31
    United States to generate these how and.
  3. reper on 31.01.2014 at 12:18:35
    You can also use the can very.
  4. Elnur_Guneshli on 31.01.2014 at 20:12:26
    Cops got there?) nationwide sexual.
  5. Alisina on 31.01.2014 at 13:10:42
    The world's most iconic heroes that you must phone's use even following service subscriptions.