Instr function in Oracle has to be replaced by Position Function

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Instr function in Oracle has to be replaced...

Rate Topic

Display Mode

Topic Options

Author

Message

roushank2000

Posted 5/26/2009 4:52:49 AM

Forum Newbie

Group: Forum Members
Last Login: 6/9/2009 9:54:22 AM
Posts: 1, Visits: 6

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

Post #15518

Adeel.Chaudhry

Posted 5/26/2009 5:05:47 AM

Supreme Being

Group: Forum Members
Last Login: 10/18/2009 5:48:26 AM
Posts: 273, Visits: 1,214

Hello,

Following thread contains the answer of your question:

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

Regards,

Adeel

Post #15519

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:48pm