Instr function in Oracle has to be replaced by Position Function

UDA

Instr function in Oracle has to be replaced by Position Function

Hi,

I have to convert this Oracle Query to Teradata Query with the help of Position function.
substr('F9992DD2-E49B-4EC6-B34D-D543648F97F4-E8D6BD0B',1,instr('F9992DD2-E49B-4EC6-B34D-D543648F97F4-E8D6BD0B','-',1,4))

The required result set is: F9992DD2-E49B-4EC6-B34D.

could you please help me with implementation of this function in the above Query..

Thanks in Advance...
Roushan
1 REPLY
Teradata Employee

Re: Instr function in Oracle has to be replaced by Position Function

Hello,

Following thread contains the answer of your question:

http://www.teradata.com/teradataforum/Topic13579-1-1.aspx?Highlight=instr

Regards,

Adeel