Archives of the TeradataForum
Message Posted: Wed, 10 Jan 2007 @ 13:31:48 GMT
| Subj: | | Re: How to insert a new-line char? |
| |
| From: | | Victor Sokovin |
| | Could anyone tell me how to insert a '\n' character into a > VARCHAR column in TD? | |
You could try the following:
ins some_table(COL1)
sel 'Line1' || '0A'xc || 'Line2' COL1
But I am not sure whether you will be able to display the data the way you intend it. You might need to check similar threads in the archives
or post a new question with the details of the client tools you are using. Some client tools strip \n.
Regards,
Victor
| 
