I have column in a large table that contains paragraphs of material for each record. The material was first entered in Access and later upsized to SQL 2000.
In SQL the column is a 'ntext' data type.
When I spit this back out into HTML of course the paragraph breaks are not preserved.
Any suggestions for some query language, or a procedure, that I could use to search this column for paragraph markers (or whatever the ASCII equivalent is) and replace them with a <P> tag?
...I know, I know, "Go take a damn SQL class!". Someday I'm going to be forced to.
In SQL the column is a 'ntext' data type.
When I spit this back out into HTML of course the paragraph breaks are not preserved.
Any suggestions for some query language, or a procedure, that I could use to search this column for paragraph markers (or whatever the ASCII equivalent is) and replace them with a <P> tag?
...I know, I know, "Go take a damn SQL class!". Someday I'm going to be forced to.
Replace paragraph markers in Ntext field?