I have a table with some vehicle information. Theres a unique name for each vehicle that has a multi part convention like this: NT2763
The first letter is the city the car lot is on, the second the major lot section, and the number increments based on what city. Now although vehicles are not added every day the client still wants this number to be auto generated when the go to add a new vehicle to the inventory. How can I automate this. Ive thought of computed columns but this data comes from seperate tables. Is a trigger the best way? Can anyone point me to some examples of this conditionl non-identity column.