how to insert chr(10) in teradata

Database
Enthusiast

how to insert chr(10) in teradata

Hi,
i want to insert a new line in a select query.
In oracle i will write : select 'Mon'||chr(10)|| 'ica' from dual;
the output will be : Mon
ica.

how can i achieve this in teradata.
1 REPLY
Enthusiast

Re: how to insert chr(10) in teradata

Still not able to find the solution ::
http://www.teradataforum.com/teradata/20050817_101530.htm