I want to strip off the last three characters from an item number. The only thing is tht every item number is not the same lenght. The last three characters of this number are packing codes that I do not need. Fore example I can have all these numbers:
Say I wanted to Select all this and place it in another table. A new table that I would create. Lets call it NewSales_history. how would I go about this, I still want to keep the current table the way it is.