All Forums UDA
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 773 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=instrRegards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.