How to add line feed and carriage return to bullets in a string
Posted on 2010-08-24
I have a string that contains bulleted points all in one line and I want to add carriage return and line feed after every bullet except the first one. Here is the code that is not working for me:
DECLARE @KeyPoints VARCHAR(1000)
SET @KeyPoints ='• ABC • DEF • GHI • JKL'
SELECT REPLACE(@KeyPoints, ' • ', ' • ' + CHAR(13) + CHAR(10)) KeySellPt
When I display this in html, I see all the string in one line rather than multiple lines as should it be after the replace statement.
What is wrong going on here? Any clues?