Yes, DISTINCT will do that.

Just as an observation, you REALLY need to think about normalizing that bundle of fun. There are a few "issues" in what you've posted so far, and I think what I can see from here is only the tip of the iceberg... Guaranteed, no doubt in my mind, it is only a matter of time before it comes to bite you.

-PatP