Replacing a carriage return with a space in mysql statement

Question:

Experts, how do I use the replace function to replace an Enter key stroke with a space or a carriage return with a space.  I need to use the ascii equilavent correct?  Here is what I tried and its not working

select Replace(bt.View_Status,’^M CR’,”)
from bit_rec_item bt

Solution:

Try this

select REPLACE(REPLACE(bt.View_St