can some one help me i hate a table that has a matched pair number

ie..

icqrm006520050406142936mxfs100100985-ddpgw000020041209004511mxfs100088798

icqrm006520050406142936mxfs100100995-ddpgw000020041209004512mxfs100088328

icqrm006520050406142936mxfs100100995-icqrm006520050406142936mxfs100100995



and im trying to make a new table that has a procedure to go throught that original table and search if the left side of the dash is = to the right side of the dash and if it is exclude that from the info sent into the new table i want to create...if anyone can help it would be appreciated