 |
 |
Archives of the TeradataForum
Message Posted: Mon, 16 Oct 2006 @ 15:56:44 GMT
| Subj: | | Re: TRIM and WHITE Spaces |
| |
| From: | | Geoffrey Rommel |
| | probably you need a way to get rid of the nulls in front of the data for that column .. TRIM certainly doesn't look like the
candidate... | |
Just to clarify, TRIM can remove any leading characters, including nulls, as shown below. To remove both nulls and spaces, you would have to
nest two calls to TRIM.
sel trim(leading '00'xc from '000000414243'xc);
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
Trim(LEADING '
--------------
ABC
| |
