<NEWLINE> in HANA Messagebox

Stefan Thole

• February 26, 2020 12:26

Hi everyone,

I apologize if this is a newbie question, but how do I get the <NEWLINE> to work in a HANA SQL statement?  I have tried both double pipe and CONCAT, but I do not seem to get it work.

 

 

Any ideas?

 

Thank you and best regards,

Stefan

Vote

0

• 

  Nadav Caridi

  • March 02, 2020 11:28

  Hi, 

  this works for me  :

  SQL:SELECT N'UF-623 ' + CHAR(13)+CHAR(10) + ....

  but I'm not on HANA. 

  Hope that helps. 

  -Nadi. 

Please sign in to leave a comment.