I am trying to replace a string with carriage return. How to use the carriage return in sap hana queries ?
select 'firstname'||Char(13)||'lastname' from dummy;
I am expecting the result as
But the above query only results in firstnamelastname.
Please let me know how to include a new line (Carriage return) inside a string?