Replace Line Breaks In SQL Command

[autumnEND]

Hi, is there a command which lets you change the line break from vbcrlf to <br> in the sql command?

so once displayed on the web page in the grid view label.
it will display the line breaks automatically.

or is this something that i should only do on the html side of things and not in the sql command

SELECT [newsTITLE], [newsARTICLE] FROM [news]

it is the newsARTICLE field that im wanting to replace the line breaks in

the data is entered into SQL using a webform.

at the moment it will display the text with no spaceing at all.

any help would be greatly appreciated

 

[bborissov]

SELECT [newsTitle], REPLACE(newsARTICLE,CHAR(13)+CHAR(10),'<br>') AS newsARTICLE FROM [News]

Borislav Borissov