Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SUBSTR & INSTR-Oracle

Status
Not open for further replies.

JACKJPR

Programmer
Mar 30, 2004
3
US
Hi

I am looking for the Oracle Function's like SUBSTR & INSTR in Informix....

Is there is any function in informix Like this....

Looking forward for your Helps...

Thanks in advance for spending your valuable time

Thanks
Jack
 
Hi Jack,

If you are using version 7.3 and above you will get bunch of built-in functions at your disposal. substr() function available too. I'm doubtful about instr() function.

I would direct you to a web link wherein you get more information about the built-in function available in different versions. Since it is a korian site, contents are mingled with korian & english. You will find source code for some useful functions in the form of stored procedures. I saw the instr() source amoung other functions.


Regards,
Shriyan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top