|
Archives of the TeradataForumMessage Posted: Tue, 19 Aug 2003 @ 09:01:23 GMT
<-- Anonymously Posted: Tuesday, August 19, 2003 04:09 --> sel * from test; $MOBM$UIFPRIVATE&D&H I want to get only the characters starting from position 8 onwards till the position '&D&H' i.e. I want entries as IFPRIVATE&D&H 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 Thanks
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||