mirod's solution is correct. However, you may wish to rethink your database design. Either adopt a multi-value database which ignores the first normal form and allows multi-value fields (like UniData or UniVerse), or extract the multiple values out to another table and have a reference to that table in your original table.

Violating the first normal form in a database seriously interferes with maintenance and scalability. As the database grows, new programmers (and old ones) need to be aware of the multi-value fields and create new code to deal with them. If they forget, or if the new code is buggy, you can easily wind up with corrupted data.

I realize that switching databases is probably not a viable option, so I'd recommend creating a new table.

Just a thought... accept or disregard as you will.

Cheers,
Ovid

Join the Perlmonks Setiathome Group or just go the the link and check out our stats.