How to breakup data

[Olivia_Crazy_Horse]

I have a column that contains email addresses, separated by a comma.Some records contain one address, some contain two, others in excess of ten.

When I cfoutput the data into a table, the width of the table has to be 760.But the email column is so wide that it causes the entire table to exceed 760.

How can I breakup the email addresses to be on multiple lines so that the entire table can stay within 760 ?

[Newsgroup_User]

Olivia Crazy Horse wrote:
> How can I breakup the email addresses to be on multiple lines so that the
> entire table can stay within 760 ?

replace(yourEmailAddressData,",","<br>","ALL")

[Dan_Bracuk]

Normalize your database and you won't have these types of problems.