Archives of the TeradataForum
Message Posted: Fri, 02 Jul 2004 @ 15:19:10 GMT
| Subj: || || Substr question |
| From: || || Grenwelge, Bill A. |
At one time I was thinking that you could do the following.
select select substr('265CPI0', 7, -1)
So that you could basically substring backwards in a string. This now gives an error saying the string subscript is out of bounds. It
has been a couple of years since I have had to try to do this. I have come up with a way to get what I want, but was thinking that I could use
the negative in the last position of the substring to have it step backwards. Does anyone else remember this being possible?
Teradata Certified Master
Data Warehouse - Teradata DBA
Union Planters Bank