Archives of the TeradataForum
Message Posted: Fri, 27 May 2005 @ 13:51:27 GMT
I think what the OP means is the following:
Removes characters from the left of Char, with all the leftmost characters that appear in Set removed. Set defaults to a single blank. Oracle begins scanning Char from its first character and removes all characters that appear in Set until reaching a character not in set and then returns the result."
It is rather "advanced", isn't it?
I think the standard recommendation here would be to write a User Defined Function (UDF). Easier to say that than to follow the advice, especially for a beginner.
The good news is that NCR have provided a set of UDFs for Oracle functions. They are available for download from the NCR site. I cannot recommend them personally (not that they need to be recommended) because I have never worked with them but they might be worth checking out at least as examples of what is possible in terms of extension of standard TD functions.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|