Remove comma and carriage return from long

Carriage Return = Chr(13) Line Feed = Chr(10) REPLACE(X.DIPLOMA_DESCR , Chr(13) , ' ') SELECT REPLACE(REPLACE(REPLACE(X.DIPLOMA_DESCR , Chr(13) , ' ') , chr(10) , ' ') , ',' ,' ') --replace carriage return, line feed and comma from description--