How to replace LF/CR in a SELECT statement

[Simon]

Hi,

I'm trying to extract data from mySQL that contains ASCII 10/13 (LF/CR). Unfortunately I can't pre-/post-process the data, so I need to replace these characters (with "<BR/>") within the SELECT statement.

In SQLServer (sorry!) I would do it like this:

SELECT REPLACE( suggestion_text, (chr(10)+chr(13)), "<br/><br/>") AS suggestion_title, suggestion_title, suggestion_author, suggestion_date
FROM newwebsite_ideas
ORDER BY suggestion_date DESC

I tried this in mySQL and got the following error:

"ADO Error # -2147217900 NativeError 1064 Description [MySQL][ODBC 3.51 Driver][mysqld-3.23.49-max-debug]You have an error in your SQL syntax near '(10)+chr(13)), "