how to insert chr(10) in teradata

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

how to insert chr(10) in teradata

Rate Topic

Display Mode

Topic Options

Author

Message

Sunar

Posted 4/1/2008 2:00:15 AM

Forum Guru

Group: Forum Members
Last Login: 7/30/2009 8:24:40 AM
Posts: 53, Visits: 371

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.

Regards:

Javeed

Post #11106

Sunar

Posted 4/1/2008 4:35:47 AM

Forum Guru

Group: Forum Members
Last Login: 7/30/2009 8:24:40 AM
Posts: 53, Visits: 371

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

Regards:

Javeed

Post #11107

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 7:19pm