Skip to Content
0
Former Member
Apr 07, 2014 at 12:06 PM

Carriage Return in string

2209 Views

Hi All

I am trying to replace a string with carriage return. How to use the carriage return in sap hana queries ?

eg,,

select 'firstname'||Char(13)||'lastname' from dummy;

I am expecting the result as

firstname

lastname

But the above query only results in firstnamelastname.

Please let me know how to include a new line (Carriage return) inside a string?

Regards

Suman