Can not find alternative of replace function in TD SQL query

Database
N/A

Can not find alternative of replace function in TD SQL query

I have some ORACLE SQL query which I need to convert to Teradata compatible.

I am using teradata DB version 13.10.

The query used the replace function but in teradata there is no replace function in teradata. And also I saw if I can install the UDF utility then I can get the Oracle functions. Like oReplace.

But the problem is I do not have any access to install things in DB or also it is difficult for me to contact the DBA out there.

The query in oracle -- 

select  replace(replace(strvalue,'--Major',''),'--Mainor','') as MyValue from TableName where startdate > 'somedate'

Can you help me converting this query to TD compatible.

Thanks in advance.

Arpan

Tags (1)
2 REPLIES

Re: Can not find alternative of replace function in TD SQL query

I can't help you with 13.10, but it may interest you to know that 14.0 has implemented OREPLACE and many other Oracle-like functions as built-in functions.

Re: Can not find alternative of replace function in TD SQL query

Hi, I think need to go with CASE statmnt in td 13.