 |
 |
Archives of the TeradataForum
Message Posted: Wed, 02 Jun 2004 @ 16:58:05 GMT
| Subj: | | Re: Newline char (or any other ASCII char) in a VARCHAR field |
| |
| From: | | Dieter Noeth |
Anomy Anom wrote:
| | How can I insert programmatically a newline char (or any other ASCII char) in a VARCHAR field. | |
| | I want to concatenate to a string a newline and then concatenate another string and so on. | |
select 'bla' || '0D0A'xc || 'bla';
| | Is there an equivalent for ORACLE's CHR function? | |
Check the SQL manual for Hexadecimal Literals
Dieter
| |
