--!sql
 
-- [pl] Aby usunąć znak nowej linii z tekstu
-- [en] To delete new line char from char (string)
 
SELECT TRANSLATE(TRANSLATE(authors_name, '', CHR(10)), '', CHR(13)) AS auth_name FROM authors;