Archives of the TeradataForum
Message Posted: Wed, 06 Oct 2004 @ 12:15:26 GMT
| Subj: || || SQLs potential to wrap text |
| From: || || Narayan Murthy |
Does SQL have the potential to wrap text - instead of relying on a client utilities command like '.FOLDLINE' (From BTEQ) to achieve this
wrapping of text.
i.e. if I were to give a SELECT statement selecting a character data type column which contains a string say > 80 (> default width
specified by BTEQ) - is there a possibility to wrap the text without using any BTEQ related command like FOLDLINE or WIDTH or exporting it to a
file with a .EXPORT REPORTWIDE option.