Sorry, another Newbie question -- As I redesign my Database and application, I want to correct some design problems. One of them is that in my Supplier table, I have one column for Contacts. I'd like to move that column to another table with multiple fields, such as First Name, Last Name, etc. The problem is that the data in that field is not consistant. It could contain the following: Null FName FName LName FName1, FName2 FName1, FName2, FName3 So, what would be the best way to break it apart? Should I use a temporary table? I thought of using SSUB, but that wouldn't work for the ones that had a First and Last name in the field with just a space in between. thanks, Lin MacDonald
