troubleshooting Question

CFMAIL & SQL NTEXT Formatting

Avatar of bodachs
bodachs asked on
Microsoft SQL ServerWeb ServersMicrosoft SQL Server 2005
6 Comments3 Solutions457 ViewsLast Modified:
Greetings,
Maybe this is easier than I think but I need to ask anyway.  

1)  I use SQL Server NTEXT and the only way I can have paragraph line breaks stored in the fields is by putting the <p> at the end of the sentence, where I want the next sentence to have 2 line spaces between.  Is there a way to format text in NTEXT that handles <p> tag in SQL Server 2005?  Is there a better way to do this?

2)  When I run a query to send specific information from the dbase it populates the CFMAIL output OK, but the <p> tags are visible.  Is there a way to make the <p> invisible or a way to script this so that it ignores the <p> tag?

Thanks,
G
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros