Hi.
Is there a way to remove carriage returns and line feeds from a field in SQL.
Here is what I have at the moment:
CAST(m.Description AS VARCHAR(8000))AS "Product Description"
(have had to cast as VarChar because of problems with aggregate functions in rest of query).
Problem is that this m.description field has carriage returns and line breaks in it .. how do I remove these inside the SQL statement?
thanks