 |
 |
Archives of the TeradataForum
Message Posted: Tue, 02 Sep 2014 @ 11:56:06 GMT
| Subj: | | Re: Replace string in teradata |
| |
| From: | | Dieter Noeth |
Sridharan Manoharan wrote:
| | I have requirement to replace the ?_? to none, for example:- ?6_in_6? to 6in6 | |
| | Tried with oreplace but not working. | |
| | SEL oreplace(COLUMNNAME,'_','|') FROM DATABSASENAME.TABLENNAME | |
What is "not working"?
Because it replaces '-' with '|' instead of ''?
For single digits you should better switch to oTranslate:
oTranslate(COLUMNNAME,'_','')
Dieter
| |
