Need Help With Exploding CSV Data Within DB

[eluser]Jay Logan[/eluser]
I don't really need anything to help with locating zip codes. In fact, you can forget that zip codes are being used. Let's just say the I have a table with 100 store locations. For each store location record, there is a column which has a several 5 digit numbers separated by a comma. They could be zip codes, product ID's, whatever. What I need to do with CI is read the column with all the CSV numbers and match each CSV number to another table which will look up info on that number (zip code info, product info, whatever).