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?