All Forums Enterprise
roushank2000 1 post Joined 05/09
26 May 2009
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

Adeel.Chaudhry 272 posts Joined 04/08
26 May 2009

Hello,

Following thread contains the answer of your question:

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

Regards,

Adeel

You must sign in to leave a comment.