Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 explanation

Author  Topic 

aylin_sk
Starting Member

25 Posts

Posted - 2005-01-26 : 05:01:53
Why do we need to use INSTR and SUBSTR in some sql examples?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-01-26 : 05:17:11
emmm those aren't sql server functions... seem like VB to me.
give us an example.
equivalent of instr in sql is charindex or patindex, and substr is Substring in sql.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

aylin_sk
Starting Member

25 Posts

Posted - 2005-01-27 : 05:16:12
These are oracle functions...
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-01-27 : 06:41:04
...and we're a SQL Server site. Probably get more help from...

http://dbforums.com/
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-01-27 : 06:43:19
Or www.oracleteam.com




Damian
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-01-27 : 11:17:23
Did ski ever resolve his connectivity issues?

And who said you need to use those functions anyway?



Brett

8-)
Go to Top of Page
   

- Advertisement -