Remove carriage returns from a field

select oTranslate(afield, '0A0D'xc,' ') from atable