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)
 Is ther InStr function in SQL?

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2006-02-11 : 17:58:29
There is a function call InStr in Access to find out a character in string. What is in SQL server?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-02-11 : 18:10:40
see "String Functions" in Sql Server's Books Online

charindex
patindex

Be One with the Optimizer
TG
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-02-12 : 02:25:35
or possibly the LIKE operator?

Kristen
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-12 : 02:49:30
Instr finds out the position of a character in a string

Do you want to find out if the character exists in a string? Or the position ?

Go to Top of Page
   

- Advertisement -