I'm building a relatively simple database. The goal is to compare the recorded weight of a bag, as presented in bar code form on the bag itself, to the actual weight of the bag as weighed by a user by putting the bag on a scale. Easy peasy. One hurdle I need to overcome is that the data from the bags' barcodes contains both the weight and lot number. I need a way to automatically split out those two pieces of data and insert it into separate columns in the database when the data is entered. I'm assuming there's a way to make this happen. The scanned data is uniform, so splitting it at a specific number of characters won't be a problem. I seem to remember doing something similar in the past, but as I don't do this sort of thing on the regular, it has vanished from my brain. I vaguely recall something about a trigger. Any help would be greatly appreciated.