Archives of the TeradataForum
Message Posted: Tue, 19 Aug 2003 @ 09:01:23 GMT
<-- Anonymously Posted: Tuesday, August 19, 2003 04:09 -->
sel * from test;
I want to get only the characters starting from position 8 onwards till the position '&D&H'
i.e. I want entries as
I can use the substring function with the TRIM TRAILING command but TRIM only trims 1 character, which is a limitation.
I then used the INDEX to get the position, but this command fails. Any suggestions.
sel substring (a FROM 8 FOR INDEX (a, '&D')) from test
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|