SQL remove breakline from string results

Hi there
Sometimes while dealing with data of dynamics ax in SQL for reporting or in need of direct retrieval of data ,  we might face strings that have breaklines such as LOGISTICSPOSTALADDRESS.Address field.
If you want to drop the formating in a query select, you might use the function REPLACE(LOGISTICSPOSTALADDRESS.ADDRESS,char(10),”) as char(10) is the special char for breakline.
Also , you might need to change the carriage return or tabs in a record, if you ever need to clear those, these are the respective char codes for those.

Tab char(9)
Line feed char(10)
Carriage return char(13)

Regards Daniel Volcov