Teradata Forums / Teradata / Teradata Database / how to insert chr(10) in teradata / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 18:20:13 GMT20RE: how to insert chr(10) in teradatahttp://www.teradata.com/teradataforum/Topic11106-9-1.aspxStill not able to find the solution ::http://www.teradataforum.com/teradata/20050817_101530.htmTue, 01 Apr 2008 04:35:47 GMTSunarhow to insert chr(10) in teradatahttp://www.teradata.com/teradataforum/Topic11106-9-1.aspxHi,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 : Monica.how can i achieve this in teradata.Tue, 01 Apr 2008 02:00:15 GMTSunar