Replacing a carriage return with a comma

I have an sql statement:  SELECT Emp_LName, Emp_FName, Comments FROM Employee
The Comments field has carriage returns.  Is there a way to replace the carriage returns with a comma within the sql statement?
LoriLHSAsked:
Who is Participating?
 
Ephraim WangoyaConnect With a Mentor Commented:

SELECT Emp_LName, Emp_FName, REPLACE(Comments, CHAR(13), '.') [Comments] FROM Employee
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.